Difference between revisions of "weekend-ha"
From MGH Learn Pathology
| (2 intermediate revisions by the same user not shown) | |||
| Line 15: | Line 15: | ||
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName) | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName) | ||
|group by=scheduleFACservice.Color | |group by=scheduleFACservice.Color | ||
| − | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber=' | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' |
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}} | |default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}} | ||
| − | |} | + | |}} |
</td> | </td> | ||
<td style="width: 50%"> | <td style="width: 50%"> | ||
| Line 25: | Line 25: | ||
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName) | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName) | ||
|group by=scheduleFACservice.Color | |group by=scheduleFACservice.Color | ||
| − | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber=' | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' |
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}} | |default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}} | ||
| − | |} | + | |}} |
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
