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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Fetch Query
Microsoft Dynamics CRM (Archived)

Fetch Query

(0) ShareShare
ReportReport
Posted on by Naveena 410

Hi All,

I have an scenario in CRM  we have a Entity name visit body. In this table we have multiple questions like Q1,Q2,Q3 and Q1 is related with product p1,p2. and Q2 is related with product p1 and Q3 is related with p1,p2, p3. Query is that when user select p1 product then only Q2 should come and if user select p1 and p2 then Q1 should come. Please help me out how to achieve it through Fetch query.

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at

    Naveena,

    I will suggest you to first write SQL query in CRM database to retrieve data as per your requirement.

    once your query is ready then you can use http://www.sql2fetchxml.com/ to convert your SQL query  into fetchxml.

    and use XRMToolbox (http://www.xrmtoolbox.com/) to test your fetchxml query.. Once all done then you can use this fetchxml wherever you want ..

    Hope this will help..

  • Suggested answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Naveena,

    You might to use Advanced Find first then you see the result.

    Then you download the XML Query.

    Then you replace your 'static' value to the 'dynamic' variable.

    Hope this help.s

    Thank you!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans