Maintaining Query Resources

Maintaining Query Resources

In addition to the Mapper and data tanks, all query resources require a Selector to define the data to retrieve from the Repository. You can also add a Results Pager to return data in increments.

Returning Data in Increments

In some cases, large numbers of Content Items to assemble may cause performance problems. In thos situations, you can improve performance by returning data in increments rather than all at once. To return data in increments, add a Result Pager to the query Data Pipe:

  1. In the Workbench Menu bar, choose Insert > Result Pager.

    The Workbench adds a Results Pager to the resource.

  2. Drag the Results Pager onto the Data Pipe.
  3. Double-click on the Results Pager to open it,.

    The Workbench displays the Result Pager dialog.

  4. Specify the Max rows per page. The default is -1, whcih returns all rows on one page.
  5. Specify the Max pages. The default is -1, which returns all pages. Usually, you will not want to change this value.
  6. If desired, specify the maximum number of links to other pages for each page of results returned in the Max displayed page links field.
  7. Do define sorting criteria:
    1. Click the new button .
    2. The Workbench adds a new rows to the Sorting criteria. Select the database column on which you want to sort.
    3. You can add multiple rows to the Sorting criteria. The results are sorted based on the order in which the rows are specified in the Sorting criteria from top to bottom; once the results are sorted according to the first column specified, groups of the same result are sorted according to the second column, and so on. To change to order of the sort, select a column and move it up or down to the correct position in the order.
  8. Click the [OK] button to save your changes.

Leave a comment