Difference between revisions of "EvaluationResAtt"

Latest revision as of 07:30, September 29, 2020

Anatomic Pathology		Clinical Pathology		External/Elective Evaluations

You're signed in as '. Need help?'

@@ Line 36: / Line 36: @@
 </td>
 <td style="vertical-align:top; width:38%">
-{{#arraymap: COAG;Micro;BTS;HG;HPA;HPB;|;|TaskLMM|
 {{#cargo_query:tables=scheduleRFA,evaluationResAtt
 |join on=scheduleRFA.UID=evaluationResAtt.UID
@@ Line 43: / Line 42: @@
 ,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
 ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending
-|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='MOR' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRFA.TaskAbbrev='TaskLMM'
+|where=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='STE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}'
-|group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
+|group by=QUARTER(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
 |order by=scheduleRFA.Date DESC
 |rows per page=50
 |format=dynamic table|default=}}
-}}
 </td>
 <td style="width:1%">