Define Drilldowns

Grids and Charts can be configured to drill down and display one of the following:

If a drilldown is activated for a column in the grid, a blue circle appears in the column header .

  1. Select the Query Data block containing the data for the grid or chart.
  2. From the Object tab, for SysTrack release 8.0 and above, click the Column Settings button, (or for SysTrack 7.2, click the Drilldown button).

  1. Check the Enabled option in the Drilldown Definition section.
  2. Select the Drilldown Type from the drop-down menu (Custom, Resolve, Site Visualizer, or Dashboard).
  3. Select the column that contains the system name to which you want to drill down.

Configure a Drill-Down to SysTrack Resolve

  1. Select Resolve as the Drilldown Type.

  1. Select the column that contains the system name to which you want to drill down.
  2. Select the SysTrack Resolve page you wish to open (.e.g Overview, Black Box, Health etc.). The Drilldown URL tied to your current selections displays.
  1. Click the Done button to complete the setup.

Configure a Drill-down to SysTrack Site Visualizer

  1. Select Site Visualizer as the Drilldown Type.

  2. Specify the column that contain the name of the Master Server name. If your data does not contain Master Server information, you can select Use the current server.
  3. Specify the column that contains the Group name. If your data does not include the Group name, you can select Use All Systems Group.
  1. Select the dataset, (e.g. Software Packages) that you want to have preselected when Site Visualizer opens. The Drilldown URL tied to your current selections displays.

Configure a Drill-down to another SysTrack Dashboard

  1. Select Dashboard as the Drilldown Type.

  1. Select the name of the dashboard you wish to open. The Drilldown URL tied to your current selections displays.

Configure a drill-down to Specific Information on another SysTrack Dashboard

To connect to a specific place on another dashboard (for example, system data for a specific user), your destination dashboard must have parameters in the SQL query and be configured to accept external information via a Page Context block. For more information see Defining a Page Context Data Block.

  1. Select Dashboard as the Drilldown Type.
  2. Select the name of the dashboard you wish to open. The Drilldown Definition will include a Dashboard Parameters section.

  1. Select the dashboard parameter from the Set dashboard parameter drop-down menu.
  2. From the to value from column drop-down menu, select where the value for that parameter should come from, or key in a static value.
  3. Click the Add Parameter button.
  4. Repeat steps 3 through 5 above for each parameter you wish to add to the Drilldown URL.

Configure a Drill-Down to a Custom URL

The Custom option opens a URL when the user double-clicks the cell in the grid. To set up a drilldown to a custom URL:

  1. Select Custom as the Drilldown Type.
  2. Enter or cut and paste the URL into the Drilldown URL field.
  3. You can insert the value of a cell from the selected row into the URL so that when a user double-clicks a cell in the grid to drilldown, the contents of the cell will be passed along with the URL:
    1. Place the cursor where you want to insert the value.
    2. Select the column, and click the Insert button. The inserted value is marked with @{<inserted value>}.