Copy the below SQL and replace “SEARCH_STRING”. SEARCH_STRING can be any string associated with the form. E.g., form name, field name, table name, column name, etc. Run the SQL from OpenSpecimen database console (or SQL client) SELECT
xt_parent.form_caption,
xt_parent.db_table_name,
xt_child.field_caption,
xt_child.db_column_name
FROM dyextn_containers c,
-- Extract Top-Level Form info
XMLTABLE('/container'
PASSING XMLTYPE(c.xml, 873)
COLUMNS
form_caption VARCHAR2(255) PATH 'caption',
db_table_name VARCHAR2(255) PATH 'dbTableName'
) xt_parent,
-- Extract Field-Level info
XMLTABLE('//entry/*'
PASSING XMLTYPE(c.xml, 873)
COLUMNS
field_caption VARCHAR2(255) PATH 'caption',
db_column_name VARCHAR2(255) PATH 'dbColumnName'
) xt_child
-- ONE search across the entire raw XML BLOB
WHERE DBMS_LOB.INSTR(c.xml, UTL_RAW.CAST_TO_RAW('<SEARCH_STRING>')) > 0
AND xt_child.db_column_name IS NOT NULL; This will show a result like this: