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

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report

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

to convert

Was this reply helpful? Yes No
Verified answer

ankit_singhal 590 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Shashank Bhide 942 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mohit ENG on at

Like (0)

Report

Thanks for the response .

Was this reply helpful? Yes No
Jatinkumar on at

Like (0)

Report

Hi @Mohit

Was this reply helpful? Yes No
Jatinkumar on at

Like (0)

Report

Hi @Mohit ENG

Was this reply helpful? Yes No
Jatinkumar on at

Like (0)

Report

Hi @Mohit ENG

Smoke test

Was this reply helpful? Yes No