Notifications
Clear all
Topic starter
CPS 12
Is it possible to print the list of quick texts a user has or the global list?
Also, does anyone know of a way to print the search results of an inquiry from the chart reports module?
Thank You.
Posted : January 26, 2015 8:19 am
Here is a sql query that works in EMR Oracle for global quick text.
select trigtext, exp from ml.textmacros where USERID = '0' order by userid,trigtext --Global Quick Text
Here is personal with name:
select firstname, lastname, trigtext, exp from ml.textmacros, ml.usrinfo where userid = pvid
Posted : January 26, 2015 9:37 am
I am also curious about printing personal quick text lists if anyone knows how?
Thanks!
Posted : January 28, 2015 8:02 am
Topic starter
David's answer worked perfectly with the exception: instead of ml.textmacros and ml.usrifno, I used dbo.textmacros and dbo.usrinfo.
Thanks.
Posted : January 28, 2015 8:13 am
Alicia - the code after "Here is personal with name" will give you the personal quick texts. You can also run this and it will filter out the globals. If you are on CPS, change ml to dbo like Dustin mentioned.
select firstname, lastname, trigtext, exp from ml.textmacros, ml.usrinfo where userid = pvid and userid <> '0'
Posted : January 28, 2015 8:23 am
You can just export the list from the system and use WordPad to open the document. There are multiple files that come with the exported Clinical Kit. One of which is the text read out of the quick text list. I do this all the time with providers and their NP's who wish to have the same quick text as the provider.
Posted : February 4, 2015 4:13 am
Here is a crystal report someone wrote to pull the quicktext entries for a user ID. I thought it was a GE report but I guess not.
Posted : February 10, 2015 5:06 am
As a physician, I know nothing of these reports and coding referenced in the previous answers. Various local IT, and GE at CHUG that I asked didn't know how to print out Quicktext lists either. I finally got the idea to go to my Quick Text list in Administration, looked through them and wrote down the labels of the Quick Texts I wanted on a piece of paper. (Paper, imagine that) I then opened a chart on a Test Patient and typed the Quicktext Label (without the dot), moved 4 spaces, and then the dot Label to print out the text. and hit return twice to give me some spacing and did it all again until I had all my Quick texts listed in the chart document, which really didn't take all that long. I then printed the Test Patients Chart Document and then "Cut and Pasted" with actual scissors and tape and now I have a listing of the codes I tend to use. Crude I know, but it worked for me, with limited technical support.
Posted : April 25, 2015 3:11 pm
Thank you- i was able to tweak it a bit to get PVID and pull one list per provider.
Posted : July 28, 2016 11:51 am
