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

 Avinash Haridasu (Avinash.Haridasu) Morgan Stanley
Morgan Stanley
IN
Avinash.Haridasu Member since 2014 306 posts
Morgan Stanley
Posted: Jul 13, 2016
Last activity: Jul 13, 2016
Posted: 13 Jul 2016 3:44 EDT
Last activity: 13 Jul 2016 4:33 EDT
Closed

Report definition does not accept NOT in fliter criteria

I have an optimized property which is used in filter condition of RD.

My requirement is to pull all the records with some not equals condition. For example i need all records which does not contain property id as 1, 2, 3 etc..

When i use "Is not equal" in the relationship i get a guardrail warning as below:

"Filter conditions with relationship operators other than Is Equal may result in poor performance since database indexes will not be used to optimize the query."

I have tried using some NOT in filter conditions to apply but RD does not seem to accept anything other than AND and OR.

Need your thoughts on the not condition in rd or any other alternative for this requiremnt is welcome.

Thanks

Avinash

To see attachments, please log in.
Data Integration Reporting

  • Anil Kumar
Posted: 8 years ago
Posted: 13 Jul 2016 4:33 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

The guardrail warning is correct as this might affect performance.

1) Would it be possible for you to justify the warning?

2) Would be possible to get the set of values that should match instead of those that should not match?

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