Creating Drill Around queries

Use this procedure as a guideline to use the Query Builder to create calls to Internet Drill Around data.

You can create queries that go against either Drill Around Select rules or Drill Around Detail rules. A Drill Around Select rule enables you to retrieve information in a top-level Drill Around—that is, the values listed when users perform a Select on a field. A Drill Around Detail rule enables you to retrieve further information below the level of the Drill Around Select rule.

To create a Drill Around query

  1. Log in to Query Builder.
  2. Select Select Command > IDA to set the command type to Drill Around queries.
  3. In the left pane of the Query Builder, locate a form that contains the Drill Around Select or Detail that you must query.
  4. Double-click the form ID and then expand the list of Drill Around rules.
  5. Double-click the Drill Around rule you are required to use in the query.
  6. Optional. Modify the command properties for the Drill Around query. See Modifying Drill Around query command properties.
  7. When the query works correctly, save the query.
  8. To make the query available to your VB or other application, select the text of the query and then select Edit > Copy to place your query on the Windows clipboard.
  9. Click Execute to test the query.

    If the query has problems and the problems are not evident, you might want to set Execution Logging to Server Calls to Log File. See Execution Logging.

  10. When the query works correctly, save the query.
  11. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.