Notifications
Clear all
Topic starter
Good afternoon, I was just wondering if it is possible to get a report of chart popups that are active in patient charts? I have been going through the schema but haven't found a table that might have that information so thought I would ask just in case I may have missed it. We are on CPS 12.3.
Linda
Posted : May 1, 2019 6:57 am
HI,
I don't have a report, but I'm going to be creating one in the next few weeks. The fields are ProfileNotes and AlertNotes in the PatientProfile table.
Hope this helps.
Crystal
Now I realize you are looking for Chart pop ups. I will be looking for those too. If I find the table I'll share.
Posted : May 1, 2019 7:09 am
This should do the trick:
select * from FLAG where type = 1 and status = 1 and popup = 1
That is a basic query, can easily be expanded.
Posted : May 1, 2019 7:11 am
Topic starter
Thanks so much! Worked great!
Posted : May 2, 2019 9:31 am
