Report - How to add multiple values when using 'does not contain'

[MStritt]

Can you add multiple values (~24,700 numbers), when using 'does not contain'?

[Adam Stout]

It may be possible, but at some point, you'll hit a database limit on query length.   What are you trying to do here?  I would look to add a flag to the table so you can quickly filter the incidents (or whatever the records are) in or out.

What is it about the 24k items you want to exclude?

So the short answer is, maybe you can, but you probably shouldn't.

[MStritt]

Hi Adam,

Initially, I wanted to run a query that showed all contracts that didn't have any entitlements associated with them. But, found out I couldn't do this. So, I figured I could run a query against the entitlement table to show all entitlements that were associated to a contract. Then, take those contract #'s, and run a query against the contract table to show all contracts, but exclude the contracts I found in the previous query. Ideally, that would then give me all contracts that don't have entitlements associated with them. However, this condition (contract #) doesn't have an option like 'is not one of'. Hopefully that makes sense.

[Adam Stout · Accepted solution]

"Initially, I wanted to run a query that showed all contracts that didn't have any entitlements associated with them."

Did you try using a Related List Condition?  Assuming Entitlements reference a Contract, this should work to give you this.

[MStritt]

Hi Adam,

Just tried Related Lists, and it seems to provide what I need. I had tried this previously, but didn't seem to work. After another attempt, looks like it gives me what I need. Thanks!