'Contain-values' operator is not pulling all records using either FetchXML or OData call

(0) Share

Report

Posted on by Vijaya

We have a view from Advanced Find on Users entity to filter out the records based on Userrole field. I'm using 'Contain-values' operator since User role is a multiselect optionset and can contain multiple values in it. This view is returning all records that are matching the criteria on lower orgs but it is working partially on Production. It is not pulling only some records on production.

I have compared the records that are not working/pulling across the records that are getting pulled and they look fine. Same users getting pulled in lower orgs too.

I checked the network call with fetch request that is hitting the server and it looks fine but still not pulling those records. Also verified by making the Odata call in the browser and this is also not pulling those records - [organization uri]/api/data/v9.0/contacts?$select=fullname,sample_outdooractivities&$filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName='sample_outdooractivities',PropertyValues=%5B'2'%5D)

Seems like it started happening recently or to the recent records. So want to understand if 'Contain-Values' operator uses indexing/full-text indexing and due to some changes at org level, it is not pulling those records.

Any help in identifying the issue would be greatly appreciated.

Thanks,

All responses (4)

Answers (0)

Vijaya 10 on at

Like (0)

Report

RE: 'Contain-values' operator is not pulling all records using either FetchXML or OData call

Thank you.

I'll check if I can create a ticket with Microsoft.
Guido Preite 54,087 Super User 2024 Season 1 on at

Like (0)

Report

RE: 'Contain-values' operator is not pulling all records using either FetchXML or OData call

in your situation I would open a support ticket to Microsoft, you will need to replicate the issue together with the support but they can check what's going on.
Vijaya 10 on at

Like (0)

Report

RE: 'Contain-values' operator is not pulling all records using either FetchXML or OData call

Guido Preite Thanks for your response.

Yes, I have verified from Advanced find too in all orgs but only production is not pulling some (10records out of 40 qualified) records.

Verified values as well and they look fine. If I use "Equals" operator the records are pulling perfectly fine as long as there is only one option selected in those records. So it should pull using "contain-values" operator too.
Guido Preite 54,087 Super User 2024 Season 1 on at

Like (0)

Report

RE: 'Contain-values' operator is not pulling all records using either FetchXML or OData call

afaik multiselect optionset fields are not tied to indexing.

did you check with advanced find if in production you get the right results? did you check the production data to see if the values are stored correctly?