Difference between revisions of "CurrentWeekConfCall"
From MGH Learn Pathology
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
<tr> | <tr> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
<td style="width: 14%"> | <td style="width: 14%"> | ||
| − | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} | + | {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}} |
</td> | </td> | ||
</tr> | </tr> | ||
| Line 32: | Line 32: | ||
{{#cargo_query: tables=conferenceOuts,facultyMGH | {{#cargo_query: tables=conferenceOuts,facultyMGH | ||
|join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id | |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id | ||
| − | |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last | + | |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last,DATE_FORMAT(conferenceOuts.date, '%Y/%m/%d') |
|where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}} | |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}} | ||
|format=template|order by = time ASC|template=schtableouts}} | |format=template|order by = time ASC|template=schtableouts}} | ||
Latest revision as of 07:06, June 25, 2020
|
Apr 27 Apr 27 |
Apr 28 Apr 28 |
Apr 29 Apr 29 |
Apr 30 Apr 30 |
May 01 May 01 |
May 02 |
May 03 |
||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
