I would like to to create a combinding filter with one excluding filter, like this
filter in ("A", "B") and filter not in ("C")
Is there something special to do in those filter A, B, C to get the right results?
Hello Veronique
Thanks for reply, but is not like that.
I meant that i have divers favourite filters (given filternames) and i would like to combined those filters
Filtername "A" which have already certain logic and give me a result
("A" is the Filtername)
Filtername "B" which have already certain logic and give me a result
etc.
Hi Roger,
Did you try your filter to see what you get?
It would look something like:
Filter in (204563, 204567) and filter != 210084
I don't know that you are going to be able to do that in a single query. You are probably better off deconstructing the query and writing a new one.