Notifications
Clear all
Topic starter
Does anyone know if there is a way to list all the forms that use or reference (or whatever) an certain OBSTERM or SYMBOL?
For example:
Is it possible to list all the forms that write to, reference, or have a field associated with "SMOK STATUS"?
Thanks in advance!
Posted : March 21, 2014 5:44 am
Lost Creek Consulting has a tool that will do that. Apart from that, I have used this query directly against the database (Oracle in this case). This one looks for the obs term COLONOSCOPY:
select FSID, Name, Description, Formxlatedef, Pefdata, Watchers from ml.formset
where (upper(formxlatedef) like '%COLONOSCOPY%'
or upper(pefdata) like '%COLONOSCOPY%' or
upper(watchers) like '%COLONOSCOPY%' )
and Active = 'D' order by Name
Posted : March 21, 2014 6:47 am
Topic starter
I will check that out. Thanks for the info!!!
Posted : March 22, 2014 1:40 am
