I'm getting my feet wet in this blockchain world and looking to build a dapp based on Ethereum for maintaining an inventory of products. About 400,000 items that can be updated, removed or added to by anyone on who connects. My initial idea is to store product images and details in swarm (the detail would be a json object with about 100 nodes) and then store the swarm hashes in blocks instead of transactions (or something like that)
My question is, is there any way to query for products that match certain things? For instance, "location" and "type" are examples of some of the things stored in the json hash. If I were to put some of the "searchable" fields into the blockchain, would that be something I could query? (ie: I want to end up with all of the swarm hashes that represent items matching my simple query.