Difference between revisions of "testserviceschedule"
From MGH Learn Pathology
Line 3: | Line 3: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
|tables=scheduleFACservice | |tables=scheduleFACservice | ||
− | ;fields=CONCAT('🔘 ', | + | ;fields=CONCAT('🔘 ',TaskAbbrev,' - ',StaffAbbrev)=name |
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC';color=#c4acfa;text color=black | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC';color=#c4acfa;text color=black | ||
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
− | ;fields=CONCAT('Resident: ',ResAbbrev)=name | + | ;fields=CONCAT('Resident: ',ResAbbrev,'Resident: ')=name |
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT ResAbbrev='0';color=#fff88f;text color=black | ;where=TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC' AND NOT ResAbbrev='0';color=#fff88f;text color=black |
Revision as of 08:27, October 10, 2019
Cytoloy
Error: Table scheduleRFAview not found.