Difference between revisions of "CCSP"

Revision as of 11:56, March 30, 2022

2021

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

2019

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

2018

No results

Slide total: 0

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