Drugs Collected: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 32: | Line 32: | ||
=== yes/no drugs === | === yes/no drugs === | ||
<!-- | |||
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0 | |where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0 | ||
--> | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Data_Element | tables=Data_Element, Drugs_Included, | ||
|fields=sort,_pageName=page, | |join on=Data_Element._pageName = Drugs_Included._pageName | ||
|where= | |fields=Data_Element.sort=sort, Data_Element._pageName=page, Drugs_Included._pageName=DIP, drugs_included=drugs included, start_date=start, end_date=end | ||
|where=Data_Element.tables HOLDS "L_Log table" | |||
|order by=sort | |order by=sort | ||
|limit= | |limit=500 | ||
|more results text=Click here for the full list of drugs we have ever counted, with start and stop dates. | |||
|default=no results were found | |default=no results were found | ||
|format=dynamic table | |format=dynamic table | ||
|rows per page= | |rows per page=50 | ||
}} | }} | ||
<!-- old version | <!-- old version | ||