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 | + | |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 |
|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 16:18, July 26, 2020
2019
No results
2018
No results
