Convert query to Dynamics 365 CRM

(0) Share

Report

Posted on by Community member

can any one share me how to convert below xml query to query Expression CRM 365

select top 10 d.nkf_date, --d.nkf_nehrnotes,
c.nkf_nricfinno, c.contactid, c.fullname,
dc.nkf_institutionrefno,
(select top 1 m.nkf_esrfdate
from filterednkf_medicalassessment m
where m.nkf_contactid = d.nkf_patientid and m.nkf_contacttype= '100000001' and m.nkf_esrfdate is not null) as esrddate
from filterednkf_dialysistreatementassessment d
left join filteredcontact c on c.contactid = d.nkf_patientid
left join filterednkf_dialysiscenter dc on dc.nkf_dialysiscenterid = c.nkf_dcid
where convert(varchar(10), d.modifiedonutc, 126) = '2024-02-21' --and d.nkf_nehrnotes is not null
order by d.modifiedon desc

I have the same question (0)

All responses (1)

Answers (0)

AdamTravers 25 on at

Like (0)

Report

That is a SQL and not XML. If you want to convert SQL to XML (Dynamics query) there is a tool to do this within the XrmToolbox called SQL 4 CDS

(1) Within Xrm Toolbox open the SQL 4 CDS tool

(2) Copy and paste your SQL in the query window

(3) On the Toolbar click Convert -> Fetch XML

Was this reply helpful? Yes No