Notifications
Clear all
Topic starter
Working on a project, and would like to be able to display prescription data (in a form being built using VFE). I see the LISTRXNEWFULL, which is close to what I want, except:
(1) Want to be able to do something to get a delimited list, so I can control display to only a few fields
(2) Be able to do for all prescriptions for all active medications. Perhaps like the IMMUN_GETLIST allows for stipulating a class or group.
Are there any MEL commands people know of that might set me along a good path?
Thanks.
Posted : March 11, 2016 6:58 am
Joseph,
There is currently no MEL function that I am aware of that will accomplish what you are after. However, this would be a welcomed addition. Ultimately I wish GE would provide a MEL function where you could pass a SQL query string against the database and have it return the results in a pipe delimited ("|") list. This would solve a whole host of limitations with some of the current MEL functions. Can I get an AMEN! 🙂
If anyone monitoring this thread agrees, please vote this comment up.
Posted : March 11, 2016 7:27 am
HybridFax has built a program that can connect you via MEL code to the Database. You pass in a SQL query and it gives you the results. You can buy the whole faxing solution, or just the engine that interfaces with the SQL database. Shoot them an email if you are interested.
Posted : March 11, 2016 7:50 am
Thanks Daniel, I'll be sure to check that out!
Posted : March 11, 2016 8:40 am
If you are interested in the SQL interface, contact me at [email protected].
Posted : March 11, 2016 9:10 am
