Difference between revisions of "testserviceschedule"
From MGH Learn Pathology
| Line 9: | Line 9: | ||
;fields=CONCAT('Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT ResAbbrev | + | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT ResAbbrev IN ('0', '-');color=#fff88f;text color=black |
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT FellAbbrev | + | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT FellAbbrev IN ('0', '-');color=#99b1ff;text color=black |
|format=calendar|height=500}} | |format=calendar|height=500}} | ||
<hr> | <hr> | ||
| Line 26: | Line 26: | ||
;fields=CONCAT('Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' AND NOT ResAbbrev | + | ;where=TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' AND NOT ResAbbrev IN ('0', '-');color=#fff88f;text color=black |
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' AND NOT FellAbbrev | + | ;where=TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' AND NOT FellAbbrev IN ('0', '-');color=#99b1ff;text color=black |
|format=calendar|height=500}} | |format=calendar|height=500}} | ||
Revision as of 13:17, October 10, 2019
Cytoloy
Error: Table scheduleRFAview not found.
GI
Error: Table scheduleRFAview not found.
