Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

SQl query to Fetch XML query

Like (0) ShareShare
ReportReport
Posted on 17 Sep 2024 07:18:28 by
Hi,

I want to convert SQL query to Datavese fetch xml query.


Select top 100 discussion, createdon, mostrecentdate

from mspwrplt_cmty_discussionthread

where record='548sc5e'

ORDER BY 

CASE 

    WHEN createdon < mostrecentdateTHEN mostrecentdate

    ELSE  createdon

END DESC;

 
@Jatinkumar @Sudhanshu MSID
Categories:
  • Verified answer
    Shashank Bhide Profile Picture
    Shashank Bhide 927 on 19 Sep 2024 at 04:57:04
    SQl query to Fetch XML query
    FetchXML doesn't have built in CASE....WHEN...THEN, otherwise you can use the tools suggested by other community members in the post.
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 349 on 18 Sep 2024 at 08:16:16
    SQl query to Fetch XML query
    You can use CRM tool box or its simple you can go in advance find and select you entity and applied same filter there and download fetch xml file 
  • Suggested answer
    MichaelFP Profile Picture
    MichaelFP 1,526 on 17 Sep 2024 at 23:00:31
    SQl query to Fetch XML query
    to convert

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

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,769

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,466

Leaderboard

Featured topics

Loading started