Notifications
Clear all
General Discussion
3
Posts
3
Users
0
Reactions
82
Views
Topic starter
Does anyone have a report that would show me what forms are using a specific OBS term?
Posted : March 21, 2019 9:27 am
We have emr so not sure if it will be exactly the same but I used something like the following when looking for forms with PHQ related obs terms in it. select * from formset where FORMXLATEDEF like '%PHQ%'
Posted : March 22, 2019 1:37 am
Here's a query I used with CEMR:
select Name, FSID, Description, Formxlatedef, Pefdata, Watchers from ml.formset
where (upper(formxlatedef) like '%CPT-93012%'
or upper(pefdata) like '%CPT-93012%' or
upper(watchers) like '%CPT-93012%')
and Active = 'D' order by Name
Posted : March 22, 2019 3:09 am
