Difference between revisions of "CCSP"
From MGH Learn Pathology
| Line 5: | Line 5: | ||
table=dziOrder,dziCase | table=dziOrder,dziCase | ||
|join on=dziOrder._pageName=dziCase.dziorder | |join on=dziOrder._pageName=dziCase.dziorder | ||
| − | |fields=CONCAT('{{dziThumbnail{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=Case,dziCase.clinical_hx=Clinical Hx,dziCase.case_diagnosis=Diagnosis,dziOrder.collection_name=Subspecialty,dziOrder.requested_by=Faculty,CONCAT('{{ListSize{{#urldecode:%7C}}{{CaseSlidesQuery{{#urldecode:%7C}}',dziCase._pageName,'}} }}')=Slide Count,CONCAT('{{dziCasecheckbox{{#urldecode:%7C}}',_pageTitle,'}}')=QC | + | |fields=CONCAT('{{dziThumbnail{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=Case,dziCase.clinical_hx=Clinical Hx,dziCase.case_diagnosis=Diagnosis,dziOrder.collection_name=Subspecialty,dziOrder.requested_by=Faculty,CONCAT('{{ListSize{{#urldecode:%7C}}{{CaseSlidesQuery{{#urldecode:%7C}}',dziCase._pageName,'}} }}')=Slide Count,CONCAT('{{dziCasecheckbox{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=QC |
|where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' | |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' | ||
|order by=Subspecialty ASC|details fields=Diagnosis | |order by=Subspecialty ASC|details fields=Diagnosis | ||
Revision as of 06:54, October 27, 2019
2019
No results
2018
No results
