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
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?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.