Unanswered

SQl query to Fetch XML query

(0) Share

Report

Posted on by CUI10061954-0

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;

Categories:

Tables

All responses (3)

Answers (0)

Suggested answer

Shashank Bhide 758 on at

Like (0)

Report

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 86 on at

Like (0)

Report

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 1,063 on at

Like (0)

Report

SQl query to Fetch XML query

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

to convert