Hi,
I’ve got an inventory database that tracks, among other things, gaming consoles, controllers and games.
I have a main Category (“Gaming” in this case) and a Sub-category from which I might select “gaming”, “game”, “console”, “controller” etc.
I’m trying to up a set of Search Rules that finds all gaming items that are not games. So it needs to include Category “Gaming” and Sub-Category “gaming” (there’s a Sub-Category “gaming” because the main category might be “monitor”) and then exclude items where the Sub-Category is NOT “game”.
The screenshot doesn’t work, obviously, because the last rule includes everything else in the inventory.
How do I set up a set of rules that:
Includes Category “Gaming”
Includes Sub-Category “gaming”
and then
Excludes Sub-Category “game”
Thanks in advance!
-
This topic was modified 5 days, 11 hours ago by
Chris Parker.
Attachments:
You must be
logged in to view attached files.
Hi Chris,
So your query is built like this:
(Category contains "Gaming" OR Sub-Category contains "Gaming") AND (Sub-Category does not contain "-Game")
So either Category or Sub-Category can contain “Gaming”, but it doesn’t mean that both need to contain Gaming. One or the other. But then Sub-Category must exclude “game”.
It may be easier for me to diagnose this if you email me an archive of the form so I can experiment with the query. Perhaps there is a bug that’s causing this to fail.
Thanks,
Brendan
Thanks Brendan, but I’m being really dull.
Where do I insert your query or how do I contruct that logic as rules in Search Details?
Hi Chris,
I was just interpreting and displaying your query in a different way. There’s no way to input your query in the format I provided. I thought it might help clarify what’s actually going on.
But I won’t be able to figure out what’s going wrong without a sample from you. If you could email me an archive of your form that would help greatly.
Thanks,
Brendan
.
