Skip to main content
Contact a Moderator

Question

12
Replies
1164
Views
 Rosy Salame (RosyS608)
Salame

Salame
RosyS608 Member since 2015 71 posts
Salame
Posted: June 6, 2016
Last activity: June 10, 2016
Posted: 6 Jun 2016 13:29 EDT
Last activity: 10 Jun 2016 4:44 EDT
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 Experience Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 7 Jun 2016 2:54 EDT
Rosy Salame (RosyS608)
Salame

Salame

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: 5 years ago
Posted: 7 Jun 2016 9:43 EDT
Samanth Reddy Chintakuntla (SamanthReddyC)
Cognizant

Cognizant
US

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

Accepted Solution

Posted: 5 years ago
Posted: 7 Jun 2016 10:38 EDT
Samanth Reddy Chintakuntla (SamanthReddyC)
Cognizant

Cognizant
US

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: 5 years ago
Posted: 6 Jun 2016 14:59 EDT
Phani Sahukaru (sahup1)
PEGA
Architect - Financial Services
Pegasystems Inc.
IN
  • also please try the relationship option "is not equal" with comma separated list ...
Posted: 5 years ago
Posted: 7 Jun 2016 2:53 EDT
Rosy Salame (RosyS608)
Salame

Salame

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: 5 years ago
Posted: 10 Jun 2016 4:41 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

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

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice