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

Leave a comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
By submitting this form, you accept the Mollom privacy policy.

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.