When data is retrieved from an environment using a Query or Search & Select action, it remains in memory until a Display Action places that data into the workbook based on a Display Map.

Note

To create a Display Action, you must have an existing Display Map.


To create a Display Action

  1. Click the lower section of the Actions button and select Display.
  2. In the Action Name field, enter a name for your Display Action. Use a name that describes the records to display.



  3. Click the drop-down next to Display Map to select the Display Map to use.
  4. To disable excel events while performing display actions, select the Disable Excel Events during execution checkbox.
  5. To display query filters in the worksheet, select the Show Query Filters checkbox.
  6. Click Save.

To show query filters in the worksheet

Perform the following optional steps when creating a Display Map if you want to display the filters used in any Query or Search & Select actions used to display records for the specified Display Map.

  1. Select the Show Query Filters check box.
  2. Select one or more Display Map Objects for which you want to display the query filters for during runtime. 
  3. For each Display Map object selected, enter a worksheet cell location in the Filter Location in Excel field. At runtime, all configured filters for queries used in that Display Map are populated in the specified cell location.  For example, specifying the filter location Sheet2!B2 displays query filters for the corresponding Display Map object in the cell B2 on Sheet 2. You can also specify a named range as a filter location.



  4. Click Save.

Runtime Behavior: When the App is executed during runtime, the query filter is displayed in Sheet 2 in cell B2. The query filters can also be displayed in merged cells.