Drugs Collected: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 5: | Line 5: | ||
==Pharmacy List== | ==Pharmacy List== | ||
=== Counted drugs === | === Counted drugs === | ||
<!-- query for full list --> | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Drugs_Included, Data_Element | tables=Drugs_Included, Data_Element | ||
|join on=Drugs_Included._pageName = Data_Element._pageName | |join on=Drugs_Included._pageName = Data_Element._pageName | ||
|fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, | |fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, start_date=start, end_date=end | ||
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" | |where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" | ||
|order by=sort | |order by=sort | ||
|limit=0 | |||
|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=50 | |rows per page=50 | ||
}} | }}4\ | ||
<!-- query for | '' Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves. '' | ||
<!-- query for currently collected list --> | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Drugs_Included, Data_Element | tables=Drugs_Included, Data_Element | ||
|join on=Drugs_Included._pageName = Data_Element._pageName | |join on=Drugs_Included._pageName = Data_Element._pageName | ||
|fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, | |fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, <!-- start_date=start, end_date=end --> | ||
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" | |where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0 | ||
|order by=sort | |order by=sort | ||
|default=no results were found | |default=no results were found | ||
|format=dynamic table | |format=dynamic table | ||