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('🔘 ',StaffAbbrev,'-',TaskAbbrev)=name
+
;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.