Decks: See which cards are "In-Use" and which are "Available" via linking to Collection

 avatar
IndianaTuna avatarIndianaTuna 55 days
{"ops":[{"insert":"Hi there,\n\nI recently digitized all of my decks and my bulk collection. I started brewing a new deck and I came across a use case that I'm not sure is currently possible.\n\nWhen building a deck from scratch, often you add cards you may already own. Currently, when comparing your collection to a deck, there is a small blue or green banner showing the card is in your collection, or a similar printing is instead. The next question I have is: is this card \"in-use\" in another deck, or is it still in my bulk collection. \n\nHere are two examples:\n 1. I have two decks that both want a [[Skullclamp]]. I only have one copy, so I would like a banner that shows \"in-use\" in another deck. I would have to pull that card from that other deck to put it in this one, or purchase an additional copy."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"2. I have two decks that both want a [[Cultivate]]. I have two copies: one is in-use, and the other is in bulk. I would like a banner (or repurpose the green and blue) to reference that I have that card in inventory and that it is \"available\"."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"\nThere's lots of ways to do this (e.g. primary-key foreign-key pair for decks and collection, store \"in-use\" or \"available\" as a boolean) . Curious if having a reference to if a card is in any of your other decks is possible and/or in your roadmap?\n\nAdditional knock-on benefit if a link between decks and collections is made: if you change a card in your collection, it could update your card in your deck (e.g. update foil, quality, printing, etc).\n\nCheers\n"}]}
3
 avatar
{"ops":[{"insert":"Unfortunately there's not a great way to do this from a technical perspective. The issue is that in order to get this information, we'd need to load cards from every deck that user owns, as well as every card in their collection that matches those cards. The query to do this takes too long to reasonbly be run on the fly like that. Keeping track of how many copies are used/ unused isn't a super valid option either since it would need to be recalculated on collection import. Doing could take upwards of a few minutes for users who are uploading 20k+ card collections, and who have 100+ decks. \n\nThe intended behavior is that the user can check the info per card using the \"In decks\" tab vs the \"collection records\" tabs. While this is not ideal, giving the limitations of not wanting to pull down all of a users card data/ deck data for an entire deck it's the best we've got. \n"}]}
0