Add a Hidden Column Trigger

This feature is available only in Enterprise Edition.

To add scripted logic to the VPM hidden column, follow the steps below:

  1. If necessary, create a VPM as explained in Create a New VPM.

  2. Select the Hidden Columns tab at the bottom.

    dataModel79

  3. Select the Trigger sub-tab.

    dataModel80

  4. Enter the desired trigger script in the text box at the bottom. The trigger script should use standard JavaScript syntax, and should return an array of hidden columns (e.g., array hiddenColumns in the last statement of the script).

    Example 1. Hidden column trigger script
    hiddenColumns = ['SA.CUSTOMERS.CITY','SA.CUSTOMERS.STATE'];
hiddenColumns;

    The following parameters are available for use in the script:

    Hidden Column Trigger Script Parameters
    user

    The current user name

    roles

    Array of roles associated with this user

    groups

    Array of groups associated with this user

    parameter

    Dashboard or Worksheet parameters

    tables

    List of tables in the query

    columns

    Array of columns included in the query

    hiddenColumns

    Array of hidden columns currently defined in the VPM (for example, via API)

  5. Press the ‘Save’ button save to save the VPM.