Difference between revisions of "CCSP"

Revision as of 11:52, March 30, 2022

2021

Error: operator for the virtual field 'ServiceRequest.orderDetail' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

2019

No results

Slide total: 0

2018

No results

Slide total: 0

@@ Line 3: / Line 3: @@
 {{accordionItem|2021|
 {{#cargo_query:
-table=dziOrder,dziCase
+table=ServiceRequest
-|join on=dziOrder._pageName=dziCase.dziorder
+|fields=_pageName, reasonCode
-|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=requisition='CCSP 2021' AND orderDetail = 'order'
-|where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2021'
+|order by=authoredOn ASC
-|order by=Subspecialty ASC|hidden fields=Diagnosis
+|format=template
-|format=dynamic table|rows per page=150}}
+|template=topicpagelink}}
-<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>
 |in}}
 {{accordionItem|2019|