Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to filter an object where QMTXT begins with "INST " and where QMTXT does not contain "DEMO", "UPGRADE" or "WP ".
Here is my code....
{$<QMTXT={"INST *"}, QMTXT-={"*DEMO*", "*UPGRADE*", "*WP *"}>}
The problem is, when i lay it out as above, the first selection QMTXT={"INST *"} does not work. However, when i place the second selection before the first, this problem is reversed. Only the last selection in the code ever works. I think this may be a problem to do with using the same columns in the same set analysis. I am thinking that, for some reason, the last selection overwrites the previous one.
How do i get around this?
Don't worry, i found a fix
This is what worked for me:
QMTXT={"INST *"} - {"*DEMO*", "*UPGRADE*", "*WP *"}
This is exactly what you need 🙂
if you have same field listed multiple times as set modifiers the last one overwrites previous ones.
what you need set operators +, - or * over different sets for same field.