Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

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

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,063 Moderator 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,063 Moderator 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans