SQl query to Fetch XML query

(0) Share

Report

Posted on by Mohit ENG

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

Categories:

Microsoft Dataverse with Power Apps

All responses (7)

Answers (3)

Sort by

Verified answer

MichaelFP 2,008 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You can use a Xrmtoolbox SQL 4 CDS XrmToolBox Tool - Mark Carrington

to convert
Verified answer

ankit_singhal 624 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

Shashank Bhide 946 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

FetchXML doesn't have built in CASE....WHEN...THEN, otherwise you can use the tools suggested by other community members in the post.
Mohit ENG on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response .
Jatinkumar Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mohit
Jatinkumar Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mohit ENG
Jatinkumar Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mohit ENG

Smoke test