Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Xrm ToolBox View Designer and FetchXML Builder

Posted on by 170

Hello experts, 

I wanted to do an advanced find query and it is a complex one with many related entities in play. 

It is all working well except that I wanted to display a column from a 2nd level related entity but it's not possible OOB. 

So I'm trying to use View Designer by adding the attribute to the table to solve the issue. In the live preview it seems to be working fine and I get all the desired results. However after saving it to CRM and trying to run it, I get an error message and it won't work. 


Did anyone have a similar experience or an idea about how to solve this? Any tip could be inspiring. 

Thanks 

Hikmat 

*This post is locked for comments

  • Verified answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    You are correct - CRM is not able to link properly this field with the current view. If its not allowed/possible in the UI , if you try to insert using other tool - it might insert but will not recognize and give you this generic error.

    Limitation of CRM.

  • Hikmat Daghestani Profile Picture
    Hikmat Daghestani 170 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    I'm pretty sure it's there. But it says it has been deleted. 


    6303.image-3.png

    Could it mean that the field is not recognized in the system? Although in View designer, I did not write the field's name myself, I chose it from a dropdown list. And it worked in the preview as I mentioned above. 

  • Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,203 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    please hover on that and check what is the message

  • Hikmat Daghestani Profile Picture
    Hikmat Daghestani 170 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    When I check the columns,  I notice that it does not recognize the added attribute as correct: 

    8623.image-2.png

  • Hikmat Daghestani Profile Picture
    Hikmat Daghestani 170 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    This is a screenshot of the error message 

    7041.image.png

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    Please post the error or screenshot.

  • Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,203 on at
    RE: Xrm ToolBox View Designer and FetchXML Builder

    what error message are you getting?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans