Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rosy Salame (RosyS608)
Salame

Salame
RosyS608 Member since 2015 71 posts
Salame
Posted: Jun 6, 2016
Last activity: Jun 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

To see attachments, please log in.
User Experience
Reporting

Accepted Solution

Posted: 8 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

.

To see attachments, please log in.
Posted: 8 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

To see attachments, please log in.
Posted: 8 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

To see attachments, please log in.

Accepted Solution

Posted: 8 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

.

To see attachments, please log in.
Posted: 8 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

To see attachments, please log in.
Posted: 8 years ago
Posted: 10 Jun 2016 4:41 EDT
Rajiv Nistala (nistr) 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.

To see attachments, please log in.

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