Is anybody else seeing some odd behavior with Filter.collectionCondition? Specifically, it doesn’t seem to be joining only once on the table, but rather many times. This is the example query from the Filters and Filter Strings documentation page on Compass: links.collectionCondition("application.na…

I can’t recall seeing that before myself, but I also haven’t gone down to HQL-level logging. It’s possible your filterString is being evaluated as an OR condition instead of an AND as you intend. Can you try this filterString out and see if it works properly? links.collectionCondition("(applicati…

No difference with the parens. I agree that you’ll get at least the result set you want with your query (AD + display name starting with H), but I suspect you’d actually get MORE than that. You’ll get all identities who have at least one link with display name starting with H who also have an AD ac…

If this is behavior you can easily replicate and could document how to reproduce, I’d suggest opening a support case. Sounds like this might be a product regression/bug.

[image] Population: Fetch Identities with specific application disabled IIQ Discussion and Questions Yes! I knew it! I posted here several months ago about how the CollectionCondition Filters aren’t working properly in recent versions of IIQ, and this is exactly the behav…

Filter collectionCondition appears to be broken?

IdentityIQ (IIQ) IIQ Discussion and Questions

drosenbauer (Devin Rosenbauer) July 20, 2023, 7:48pm 5

Here’s another instance of the same problem.

Topic		Replies	Views
Is collectionCondition filter broken? (Advanced Analytics and QueryOptions) IIQ Discussion and Questions identityiq	3	47	May 20, 2026
Filter collectionCondition seems to return extra result IIQ Discussion and Questions identityiq	5	244	July 29, 2024
Population: Fetch Identities with specific application disabled IIQ Discussion and Questions rules , identityiq	6	1442	July 20, 2023
Filter to extract the links using mutiple or condition IIQ Discussion and Questions identityiq	13	220	December 6, 2025
Filter Link on Before Operation Provisioning Rule IIQ Discussion and Questions identityiq	3	87	November 23, 2025

Filter collectionCondition appears to be broken?

Related topics