Hello,
I am trying to run the following query:
"Opened by.Sys ID" "is not one of" "[sysid1],[sysid2],[etc]"
However, when choosing the operator, "is not one of" is not an available option.
I do have "is one of" as an option. ALSO, if I manipulate the url to impose the "is not one of" upon the query by changing the "opened_by.sys_idIN" to "opened_by.sys_idNOT%20IN", the query works and returns the expected "is not one of" results. So, I know that this operator would work on this query if it was available. Manipulating the URL is not a proper method of end-user access to this feature, though, nor is it usable in reporting.
|
Update 4.19.2021: That URL manipulated query can be pulled into the report designer, from a table query, by right-clicking a column header and choosing "Bar chart" or "Pie chart". |
I have checked the "Operators available for filters and queries" document and it states that this operator is available for choice fields containing strings or integers, and I find that it's typically available when building conditions for fields that have choices defined.
Is there a way for me to have the "is not one of" operator available within the drop-down list of operators for this query?
Creating a dynamic filter won't work for my needs, as I need to be able to pass varying parameters on to the query.
Thank you very much for taking the time to read this question!
Kind Regards,
Joseph
Thanks Madhuri, I appreciate your follow-up!
This post was pretty old, and I learned a new trick since the original posting.
Please check out my update in red text in the original post.
What do you think would be more efficient,
"IN > [thousands of sysIDs]" or
"NOT IN > [dozen sysIDs]"?
I'm not entirely sure which is faster - it seems like the not one of would be fastest - but database query performance factors can throw some curve balls, so I'm not ready to come to an assumption on this one.
