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;