Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

View Designer + Fetch XML xrmtoolbox

(0) ShareShare
ReportReport
Posted on by 8

Hi, 

I have a system view and for the related entity i want a "does not contain condition" which i am unable to edit in solution. 

So i thought of using view designer and fetch xml in xrmtoolbox. 

Steps i took, open view designer-> open the view-> edit query in fetch xml->return the fetch xml ->save and publish from view designer.

But for some weird reasons the results are as below, please suggest what is going wrong and how can i achieve the Does not Contain condition:

1) View is no longer visible using advance find

2) In my Solution if i look for view it is present but no Edit Query option.

pastedimage1610703835939v4.png

3) If i navigate in CRM to the entity views then i can see the view but no result, not even on refreshing the grid or page.

pastedimage1610703276081v2.png

4) If i use the advance find from this view then i can see the updated query and on pressing results all the data also.

pastedimage1610703554037v3.png

Thanks,

PS

  • Suggested answer
    RE: View Designer + Fetch XML xrmtoolbox

    Hello,

    For achieving 'does not contain' condition in a view for the related entity , it is applicable from the solution customizations but by start with the relationship lookup and then there will be an optionset with related items , below an example for a view from contact entity and related account.

    pastedimage1611652284257v1.png

    Second point for the unexpected behavior by using the xrm toolbox plugins , please make sure you are update the desired view by checking both name and id of the view and also you can double check this by create a new view from scratch with a unique name to see if same behavior can reproduced or not.

    Thanks for reaching out and please let us know if this was helpful and/or you still need help at this moment.

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! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans