Filter Wizard command

The target cell in the source file to place the filter after it has been created.

If you are configuring the command on a Button component, enter the target cell using normal cell reference syntax (such as Sheet1!A1).

If you are configuring the command on a Button tag for a Formatted Grid component, then you can specify the target cell using normal cell reference syntax or by using just a column letter. If using a column letter, such as J, then the target cell will be in the specified column on the current row of the grid.

Select one of the following to determine how users can create the filter:

• Advanced Filter (default): Users can create the filter based on literal table column names and values. The Advanced View option also supports creating limit query statements for use in Axiom queries.

• Hierarchy Filter: Users can create the filter based on hierarchy levels in defined hierarchies.

Optional. Specify one or more tables or hierarchies to limit the options shown in the Filter Wizard. Valid entries depend on the specified filter type:

• If using Advanced Filter, then you can enter one or more table names, separated by commas. The Filter Wizard will only show columns from the specified tables, as well as any lookup tables.

  For example, if you list GL2018, and that table has lookups to Acct and Dept, then all three tables will be available in the wizard.

• If using Hierarchy Filter, then several different options are available to specify the hierarchies to be shown. See the discussion following this table for more information.

If left blank, then the Filter Wizard shows all available options for the specified filter type. For Advanced Filter this means all tables, and for Hierarchy Filter this means all hierarchies.

NOTE: If desired, you can read the list of tables or hierarchies from a designated cell in the source file instead of entering the list into the shortcut parameters. To do this, use a cell reference enclosed in brackets, such as [Sheet1!A1] (or optionally just a column letter, such as [J], if you are configuring a Button tag). When using this approach, you can dynamically change the list by using a formula in the specified cell.

Optional. Specify a limit column to allow the user to create a limit query statement using this column. You can use a full Table.Column name or just a column name.

• If a Table.Column name is specified, then that table is the primary table for the wizard. This means that you do not need to specify a table name in the Tables / Hierarchies parameter. When the limit query statement is created, the full Table.Column name will be listed in the Limit parameter.

• If only a column name is specified, then you must specify a single table name in the Tables / Hierarchies parameter, to be used as the primary table for the wizard. When the limit query statement is created, only the column name will be listed in the Limit parameter.

This option should only be used when you want to generate a limit query statement for use in the Limit query data based on another table option of an Axiom query. This is the only valid use case for the limit query statement. If Limit Filter Column is populated with a column name, this changes the Advanced Filter dialog from the regular dialog to a two-step wizard that is used to create the limit query statement. This is the same user experience as when using the ShowFilterWizardDialog function or the AdvancedFilter refresh variable to create a limit query statement. For more information on limit queries, see Limit the data in an Axiom query based on another query.

NOTE: If you define a limit column, the Type must be set to Advanced Filter. Hierarchy filter view cannot be used to create a limit query statement.