Good morning,
I am working on a template for our Lipid clinic and I need to be able to pull into the note any previously tried Lipid medications. Is this possible?
Thank you in advance for any and all suggestions !!!
There is no MEL to retrieve all prior meds. However....., if you are interested I can show you a technique for executing a SQL query that will retrieve anything y0u can define from the database, e.g. each class of lipid lowering agent, start/stop dates, reason, etc. This technique requires an .exe in the client. Be glad to demo for y0u. No charge for demo/software.
There is MEL for MEDS_REMOVED and with the "delimited" option to return a listing. You would then write a loop to search thru for the 4th field (for GPI code) to only display the ones you are looking for.
Have you written MEL for arrays?
Joe Gillis