Work with Data Sources

In Geocortex Inline, a data source is the web map layer associated with a chart. Typically, every chart will have its own unique data source.

Before you can add a chart to a view, you must add the related data source to the view's Data Sources panel. The new data source is automatically added to the Data Source drop-down list on the Chart Options panel.

When you create your first view, the Data Source drop-down list on the Chart Options panel will only contain the data source for the default Points of Interest band.

 

When adding a data source to a view, you can:

There is no limit to the number of data sources you can add to a view.

Add a Data Source

There are two ways to add a data source to a view:

Configure Data Source Options

  1. Configure data source options as follows:

  2. Click Apply.

    The new data source displays on the Chart Options panel, in the Data Source drop-downlist.

Import a Data Source

  1. In the left toolbar, click Data Sources, and then click Import Data Source.

  2. In the Import window, select the view containing the data sources you want to import.

  3. Click Open.

    All data sources in the selected view are imported and added to the list in the Data Sources panel.

Add a Token

Tokens allow for the dynamic replacement of database field values at runtime. When the user runs a view in the browser, a WHERE clause filters and extracts the appropriate data. Any tokens in the WHERE clause are replaced with their corresponding field values.

For example, suppose you configure a feature action that invokes a workflow. You can use a token to replace the value of the feature at runtime.

To add a data source token:

  1. In the left toolbar, click Data Sources, and then click Add Data Source.

  2. Complete the field values as described above.

  3. Click Add Token.

  4. Configure the following required fields as follows:

  5. Configure the following optional fields as follows:

  6. (Optional) Configure one or more lookup values. Lookup values allow the user to select the value to be used in the WHERE clause that extracts the data for the view.

    You can configure lookup values that correspond to fields in an existing data source (for example, the INSPECTIONYEAR field in another data source), or you can configure hard-coded values (for example, 2020 and 2010).

  7. Click Save.

Delete a Data Source

  1. In the left toolbar, click Data Sources.

  2. The Data Sources panel lists all of the data sources configured for the view. Locate the data source you want to delete, and click its More button.

  3. Click Delete.

  4. You will be prompted to confirm the deletion. Click Yes to proceed or No to cancel.

You cannot delete the built-in Points of Interest data source.

© 2020 VertiGIS North America Ltd. All Rights Reserved.

Documentation Version 1.3