Question

1
Replies
1673
Views
Avinash.Haridasu Member since 2014 259 posts
Morgan Stanley
Posted: 4 years ago
Last activity: 4 years 2 months ago
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

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn