Configuring the query builder widget

You can set up a query builder widget to query a remote form and display entries in a table according to the created query to refresh the table with data from another form for your end users.

To set up the query builder widget

  1. In the AR System Query Widget form, create a record that lists all of the fields which are allowed to be used against the form.
  2. Click Save.
    This generates a query widget ID value, which identifies the query form and its allowable field. You use this query widget ID value when performing the Run Process action in the procedure below.
  3. If you want to add or delete fields on which you can query, continue to make changes, then click Save.

Related topic

How-the-query-builder-widget-works

To load the query builder widget into a view field

  1. In the form that includes the table which queries data from the remote form, create a view field.
  2. To load the query builder widget into a view field, call the active link with the Run Process PERFORM-ACTION-SET-QUERY-WIDGET.
    For information about this Run Process action, see Running-external-processes-with-the-Run-Process-action.
    1. Specify all parameters, including the query widget ID (GUID) and the ID of the view field.
      The query widget ID was generated when creating an entry in the AR System Query Widget form.
    2. Hide or show the query builder widget as appropriate. It does not need to be available all of the time.
      After you enter the query widget ID value, only the fields associated with that query widget ID are displayed.

      Your end users can now use the query widget builder for that form to create and execute queries. For more information, see How-the-query-builder-widget-works.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*