Drugs Collected: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (9 intermediate revisions by 2 users not shown) | |||
| 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 | ||
}} | }} | ||
=== oral/nasogastric tube drugs=== | |||
Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted (e.g. specified continuous infusions would be an exception). | |||
<!-- query for | '' Use ctrl-f to find the drug you are looking for. See [[Adding a drug to pharmacy collection]] for editing drugs. '' | ||
<!-- 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 DESC | ||
|default=no results were found | |default=no results were found | ||
|format= | |format=table | ||
|rows per page=50 | |rows per page=50 | ||
}} | }} | ||
=== yes/no drugs === | === yes/no drugs === | ||
{{#cargo_query: | |||
|where=Data_Element.tables HOLDS " | tables=Data_Element, Drugs_Included, | ||
|join on=Data_Element._pageName = Drugs_Included._pageName | |||
|fields=Data_Element.sort=table sort, Data_Element._pageName=page, Data_Element.CCMDB_label, drugs_included=drugs included, start_date=start, end_date=end | |||
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | |||
|order by=CCMDB_label | |||
|limit=0 | |||
|default=no results were found | |||
|more results text=Click hereto see the full list with names of the data in the table etc. | |||
|no html | |||
}} | |||
The (letternumber) at the beginning of the line is the column/row in [[CCMDB.accdb]]. | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Data_Element, Drugs_Included, | tables=Data_Element, Drugs_Included, | ||
|join on=Data_Element._pageName = Drugs_Included._pageName | |join on=Data_Element._pageName = Drugs_Included._pageName | ||
|fields= | |fields=CONCAT("[[", Data_Element._pageName, "{{!}}", Data_Element.CCMDB_label, "]]")=drug, drugs_included=drugs included | ||
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | |where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" AND DATEDIFF(end_date,NOW()) >= 0 | ||
|order by=CCMDB_label | |order by=CCMDB_label | ||
|limit=500 | |limit=500 | ||
|rows per page=50 | |rows per page=50 | ||
}} | }} | ||
| Line 51: | Line 61: | ||
see [[:Category:Legacy Pharmacy]] | see [[:Category:Legacy Pharmacy]] | ||
[[Category: Pharmacy]] | [[Category:Pharmacy]] | ||