web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / View Designer + Fetch ...
Customer experience | Sales, Customer Insights,...
Suggested Answer

View Designer + Fetch XML xrmtoolbox

(0) ShareShare
ReportReport
Posted on by PS10 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
    Menna El Sayed Galal Profile Picture
    Menna El Sayed Galal Microsoft Employee on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 89 Most Valuable Professional

#2
11manish Profile Picture

11manish 67 Super User 2026 Season 2

#3
Travis South Profile Picture

Travis South 39

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans