Question
"IS NOT IN" Operator inside a report definition
Hello,
I'm not finding "IS NOT IN" Operator inside a report definition, below are available operators:
How to use something similar to that?
Thanks ,
Rosy
Message was edited by: Lochan to add Category
Hello Samanth,
Thanks a lot, however, my condition in the filter should be dynamic. Please find below my scenario:
I have 2 classes: Template and Release. Inside Template class, I have a page of Release class. My report is based on Release class, I want to add a filter on it to exclude all releases that are assigned to templates, That's why, I was thinking of adding NOT IN condition , so it will be NOT IN (template.ReleaseID)
Do you have another suggestion?
Thank you,
Rosy
Hi Rosy
From your comments I assume that Release class page is of type list.
If this is a a page list class then you can define declarative index on release class and put the condition with Not In or Does Not Contain. Hope it will solve your issue.
Thanks
Sam
Hi Sam, it is a single page. not a pagelist, as I should store a single value. Is that doable?
Thanks
Rosy
Accepted Solution
Hi Rosy
Can we pass the Template.ReleaseID in the report filter and put not in condition. May be if I did not understand correctly, can you put a screenshot of what you are trying to achieve.
Thanks
Sam
.
This is what I wanted to do , but, there is no NOT IN operator in the filter
Hi Samanth, it worked for me after creating a sub-report and using not equals, thanks a lottttt
- also please try the relationship option "is not equal" with comma separated list ...
Hello Fani,
Thanks a lot, however, my condition in the filter should be dynamic. Please find below my scenario:
I have 2 classes: Template and Release. Inside Template class, I have a page of Release class. My report is based on Release class, I want to add a filter on it to exclude all releases that are assigned to templates, That's why, I was thinking of adding NOT IN condition , so it will be NOT IN (template.ReleaseID)
Do you have another suggestion?
Thank you,
Rosy
Is Not Equal will generate a NOT IN if multiple values are present. If a single value is present it will use the != operator.
Indeed! I have tried that and it worked!
Thanks a lot Rajiv for your answer!
Rosy
Hi Rosy
Have you tried Does Not Contain Option.
Thanks
Sam