Share
Reportcan 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
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
All responses (
Answers (
25
