"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
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
.
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
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