Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filters yielding too few results when PET field set to IS NULL

My team and I realized something disturbing, that if you create a filter and the first filter item is a PET table field set to "is null" then the results you get back will be limited to records with rows in that PET table.

This is quite unexpected. Our previous understanding was that we should be receiving back ALL the records from the main List, minus any records where the PET table field has a non-null value.

What is crazy is that if you start with a condition that references the main List (e.g. CUSTOMER_ID_ is not null) then you do receive the full results.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!