Test: Difference between revisions

Revision as of 17:49, 24 November 2021

sort	page	drugs included	start date	end date
sort	page	drugs included	start date	end date
13	Azoles	fluconazole (diflucan) itraconazole (sporanox) ketoconazole (ziroral) posaconazole (posanol) voriconazole (Vfend) econazole miconazole tioconazole isavuconazole	1988-07-11	2300-01-01
14	Fungins	caspofungin (Cancidas) micafungin (Mycamine) anidulafungin (Eraxis) rezafungin	1988-07-11	2300-01-01
15	Antipseudomonals	piperacillin piperacillin/tazobactam (Tazocin) ticarcillin ticarcillin/clavulanate (Timentin)	1988-07-11	2300-01-01
16	Vancomycin	Vancomycin	1988-07-11	2300-01-01
17	Fluoroquinolones	ciprofloxacin (Cipro) moxifloxacin (Avelox) levofloxacin (Levaquin) norfloxacin (Noroxin) ofloxacin (Floxin)	1988-07-11	2300-01-01
18	Carbapenems	meropenem (Merrem) imipenem (Primaxin) doripenem (Doribax) ertapenem (Invanz )	1988-07-11	2300-01-01
19	Vanco alternatives	linezolid (Zyvoxam) daptomycin (Cubicin) quinipristin/dalfopristin	1988-07-11	2300-01-01
20	3rd generation cephalosporins	ceftriaxone cefotaxime ceftazidime	2011-10-20	2013-03-11

{{Newsflash| 13:19, 2019 September 24 (CDT) |

physical location will move from JJ to GA7, Date: 2019-October-15Content that is the newsflash }}

@@ Line 3: / Line 3: @@
 {{#cargo_query:
 tables=Drugs_Included, Data_Element
-|join on=Drugs_Included._pageName = Data_Element._pageName, start_date, end_date
+|join on=Drugs_Included._pageName = Data_Element._pageName
-|fields=Data_Element.sort=sort, Drugs_Included._pageName=page, drugs_included= drugs included
+|fields=Data_Element.sort=sort, Drugs_Included._pageName=page, drugs_included= drugs included, start_date, end_date
 |where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table"
 |default=no results were found