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 the 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 Loading the query builder widget into a view field.
3. If you want to add or delete fields on which you can query, continue to make changes, then click Save.

To load the query builder widget into a view field

1. On the form that includes the table that queries data from the remote form, create a view field.
2. Update the qualification for the table field as EXTERNAL($view field$).
3. 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 Using the query builder widget.

Example: query builder widget

To see a working example of the query builder widget, download the ZIP file.