Difference between revisions of "CCSP"
From MGH Learn Pathology
(Created page with "{{#cargo_query: table=dziOrder,dziCase |join on=dziOrder._pageName=dziCase.dziorder |fields=CONCAT('{{dziThumbnail{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=Case,dziCase.cli...") |
|||
| Line 1: | Line 1: | ||
| + | {{accordion| | ||
| + | {{accordionItem|2019| | ||
{{#cargo_query: | {{#cargo_query: | ||
table=dziOrder,dziCase | table=dziOrder,dziCase | ||
| Line 4: | Line 6: | ||
|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 | + | |order by=Subspecialty ASC|details fields=Diagnosis |
|format=dynamic table|rows per page=150}} | |format=dynamic table|rows per page=150}} | ||
<br> | <br> | ||
| − | <center>Slide total: {{#cargo_query: table=dziOrder,dziSlide |join on=dziOrder._pageName=dziSlide.dziorder |fields=COUNT(dziSlide._pageName) |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' }} </center> | + | <center>'''Slide total: {{#cargo_query: table=dziOrder,dziSlide |join on=dziOrder._pageName=dziSlide.dziorder |fields=COUNT(dziSlide._pageName) |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' }}''' </center> |
| + | |in}} | ||
| + | {{accordionItem|2018| | ||
| + | {{#cargo_query: | ||
| + | table=dziOrder,dziCase | ||
| + | |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 | ||
| + | |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2018' | ||
| + | |order by=Subspecialty ASC|details fields=Diagnosis | ||
| + | |format=dynamic table|rows per page=150}} | ||
| + | <br> | ||
| + | <center>'''Slide total: {{#cargo_query: table=dziOrder,dziSlide |join on=dziOrder._pageName=dziSlide.dziorder |fields=COUNT(dziSlide._pageName) |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2018' }}''' </center> | ||
| + | }} | ||
| + | }} | ||
Revision as of 21:34, October 26, 2019
2019
No results
2018
No results
