Question

12
Replies
851
Views
RosyS608 Member since 2015 71 posts
Salame
Posted: 4 years ago
Last activity: 4 years 3 months ago
Closed
Solved

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

ScreenHunter_215 Jun. 06 20.28.jpg

How to use something similar to that?

Thanks ,

Rosy

Message was edited by: Lochan to add Category

User Interface Reporting
Close popover
Moderation Team has archived post
Posted: 4 years ago

Hi Rosy

Have you tried Does Not Contain Option.

Thanks

Sam

Posted: 4 years ago

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

Posted: 4 years ago

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

Posted: 4 years ago

Hi Sam, it is a single page. not a pagelist, as I should store a single value. Is that doable?

Thanks

Rosy

Accepted Solution
Posted: 4 years ago

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

.

Posted: 4 years ago

This is what I wanted to do , but, there is no NOT IN operator in the filter

Posted: 4 years ago

Can you put the same condition and see if does not contain  works.

Posted: 4 years ago

Hi Samanth, it worked for me after creating a sub-report and using not equals, thanks a lottttt

Posted: 4 years ago
  • also please try the relationship option "is not equal" with comma separated list ...

Posted: 4 years ago

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

Posted: 4 years ago

Is Not Equal will generate a NOT IN if multiple values are present. If a single value is present it will use the != operator.

Posted: 4 years ago

Indeed! I have tried that and it worked!

Thanks a lot Rajiv for your answer!

Rosy
Share this page LinkedIn
Copied!