How do I find the form names that use particular field values?

Document ID : KB000014186
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

When trying to develop form definitions, you may need to find which forms are using a particular data set or other value, for instance if you need to globally change that set. This can be found with a database query.

Question:

Is there a way to search the form field data values and get the form names returned, for example to find report data object references?

Answer:

For an example string of "searching", you can query the MDB database to get all the forms that include it, along with the relevant fields.

select b.form_entity_name as form, e.form_entity_name as field, a.attr_value as value
from usm_form_component_attributes a, usm_form_entities e, usm_form_entities b
where e.form_entity_id =  a.form_comp_id
and b.form_entity_id = e.form_entity_parent_id
and a.attr_value like '%searching%'
and b.form_entity_type = 2

Additional Information:

While searching the database can be useful, you should not make direct updates there; it can cause problems with cacheing and is risky in case of error.