Skip to main content

Notifications

Announcements

No record found.

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

Two optionset field

(1) ShareShare
ReportReport
Posted on by 8
We are currently using Dynamics 365 CE On-Premise version 9.0, and I've encountered an issue with one of the views on the Contact entity. I have multiple views, all sharing the same base query with slight variations in one or two conditions.

Recently, I created a new view with the same base query but added an additional criterion to check the value of an option set (let's call it 'X'). Specifically, I'm filtering records where 'X' is set to 'Yes'. Strangely, the data for this particular query never loads.

Interestingly, views with criteria for 'No' are working as expected, and views where 'X' can be either 'Yes' or 'No' also display data correctly. It's only when the condition is set to 'Yes' that the data fails to load.

I find this behavior quite puzzling, and I'm seeking guidance on how to resolve this issue. Any insights, suggestions, or steps to troubleshoot and address the problem would be greatly appreciated.

There are some 500 records as a result of this query where X = Yes, so it is not even a large dataset. I have same query for Accounts that also takes time to load but at least it loads the data. Advance find, view on dashboard nothing working. 

I have tried eliminating the queries on advance find and i know where it starts to struggle but question is this is my base query and works absolutely fine fo rother views even the same view but on account entity.

Thank you
PS
 
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Two optionset field
    Hi,
     
    Since I'm using Dynamics Online, I can't reproduce your problem.
    I did not encounter this issue when testing in Dynamics Online.
     
    I suspect this may be a bug and recommend raising a support ticket for further support if this is affecting your normal business.
     
    Best Regards,
    Dengliang Li
     
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans