Finding OpenInsight Table Used by Forms

If you have databound forms in OpenInsight and want to locate the forms bound to that table you can quickly find them with this query:

LIST SYSREPOSWINS TABLES WITH TABLES EQ 'YOUR_TABLE_NAME'

The result is a list of forms bound to the table.

What if you don't have a databound form? You can widen the search using this query:

LIST SYSREPOSWINS TABLES WITH ALL CONTAINING 'YOUR_TABLE_NAME'

The query searches the entire form for the occurence of the table name. It does this by using the built-in field ALL which represents the entire record.

Share this post


About Us

Congruity Service is a technology solutions company bringing the best technology solutions to OpenInsight projects, Drupal sites, servers, networks, and your technology needs.