Hello, in the "real world" the entities I need to search have many yes/no characteristics which I need to filter in AppSearch (for example, "is retailer", "accepts credit card", "accepts crypto", etc).
Users may filter throug one o many of this characteristics. If more than one is selected, all of them must be meet.
What's the most efficient way to store and filter in this scenario?
The obvious way is to have one field for each characteristic with a "true"/"false" or 1/0 value, but that will be a problem each time I add a new characteristic.
I thought storing the characteristics in a single CSV field, but the text filter doesn't allow wildcards. I also thought in single field numeric alternatives, but the filter doesn't allow basic math operators like MOD or LOG to disaggregate that number
Thank you in advance