Selecting Data Sources and Columns

Owned by John Kostakos
Last updated: Oct 05, 2022
4 min read

Overview

The nVISAGE Data viewer enables the user to select data sources and specify which fields (columns) to include in the report display. If the data source is based on the nVIRO Data Hub, users may select multiple logically related data sources to build more complex reports.  

Data Source Types

The nVISAGE Data Viewer is automatically configured to access data sources from the Data Hub. Other 'Custom' data sources are supported for complex queries or for queries that pre-date Data Hub implementation.

Initial Data Source and Column Selection

When a user creates a Data Viewer report for the first time, the system displays the Data Source Selection dialog box. The selection list can be searched by typing in the Select Data Source field (e.g., typing "site" filters to all data sources with the word "site" in the name).

To select a data source and columns:

  • Click to select the desired data source name. A list of data source columns is presented:

  • Click the checkboxes to select the desired data source columns. 

  • Click OK. The report executes using the selected data source and columns.

Some data sources and data columns have long names that may end up with text being cut off in the selection window. To see the full name, the selection window may be resized by clicking on the edge or corner of the selection window and dragging while holding down the left mouse button.

Adding More Data Sources

If the current data source is based on the Data Hub, additional related data sources can be added to the report.

To select a related data source:

  • Click the menu icon in the upper right hand corner of the screen.   

  • Click Add Data Source on the dropdown menu.     

  • A data source selection window is displayed. Proceed to select the desired data source and columns as described under Initial Data Source and Column Selection above.

  • The selected data source and columns are added to the report.

Removing Data Sources

Data sources may be removed from a report as follows:

  • In the row above the data source columns, right-click the name of the data source to be removed. A dropdown menu is displayed. 

  • Click Remove Data Source on the dropdown menu.        

  • Click OK. The data source and all related columns are removed from the report.

Adding and Removing columns

Columns for report data sources may be added to or removed from a report.  

To select or remove columns:

  • In the row above the data source columns, right-click the name of the data source.  A dropdown menu is displayed.

  • Click Choose Columns in the dropdown menu. 

     

  • Select the desired data source columns to add (or de-select the data source columns to be removed), as described under Initial Data Source and Column Selection above.

  • Click OK. The report is refreshed with the updated column selections. 

Making Data Sources Optional

nVISAGE supports the ability to make data sources 'Optional'.  This is useful if you wish one data source to always be included in the report, and one to be included only if there is a corresponding value. 

For example, when a user desires creates a report that lists information from both the CORE - Sites and CORE - Permit data sources, if neither data source is specified as Optional, then the report will list all records where there both a site and permit exist.  If a permit does not exist for a site, that site will not display on the report.  Suppose the user desires to list all sites, and only list permit information if a permit exists.  This can be accomplished by specifying the CORE - Permit data source as 'Optional'.

To specify a data source as optional:

  • Right mouse click on the data source name.

  • The data source menu appears:

  • Click Mark Data Source Optional

  • The query will refresh making the selected data source options

To remove the data source optionality, follow the above steps, clicking the Mark Data Data Source Required option.