I'm developing a search tool for our web application. The search tool has many different filters and options, such as product category, product price, etc. We have the ability to add zero or more flags to each product. One requirement put to our team is to be able to search for products using this flag. For example:
Find items with flags "big" and "green" and "flat" and without flags "fuzzy" and "soft" and "warm".
I have extensive back-end development experience so the SQL queries to find such items are trivial to me, but I'm at a loss on how the front-end for this should appear. At the moment, I'm using a combination of two dxTagBox items from devextreme that allow the user to select all of the flags they wish to include and exclude separately. We've also had prototypes where every flag was listed with a three-way switch (options of "include" "ignore" and "exclude"), but it was incredibly slow and far too large due to the thousands of flags available. Our management team is not liking this layout, but has no idea of how they wish this to look. Any suggestions would be welcome.