Drugs Collected: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 38: | Line 38: | ||
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=Data_Element.sort=sort, Data_Element._pageName=page, Drugs_Included._pageName=DIP, drugs_included=drugs included, | |fields=Data_Element.sort=sort, Data_Element._pageName=page, Drugs_Included._pageName=DIP, drugs_included=drugs included, end_date=end | ||
|where=Data_Element.tables HOLDS "L_Log table" | |where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | ||
|order by=sort | |order by=sort | ||
|limit=500 | |limit=500 | ||