Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 10

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,

VJ

  • Vijaya Profile Picture
    Vijaya 10 on at
    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 Profile Picture
    Guido Preite 54,087 Super User 2024 Season 1 on at
    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 Profile Picture
    Vijaya 10 on at
    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 Profile Picture
    Guido Preite 54,087 Super User 2024 Season 1 on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans