Virtual Fields

Data Source: WEBQRYV

To open the Virtual Fields tab, click a Query Name or the Need to create a new query? Click here to add link on the Data Miner screen.

The Virtual Fields tab allows you to add or view virtual fields that have been added to the selected query.

The following fields appear on the Virtual Fields tab:

Field Description
Field The name of the selected virtual field.
Expression A brief description of the calculation being used to calculate the cell values of the selected virtual field.
Length The maximum number of characters that can be displayed in the cell values of the selected virtual field.
Decimals The maximum number of decimal characters that can be displayed in the cell values of the selected virtual field.

Click a Field name to view or edit the selected virtual field properties in the Edit Virtual Field screen.

Click the Click to add field link to add a new virtual field to the query.

The following buttons allow you to complete your work on the Virtual Fields tab:

Button Function
Run Report Generates the report for the selected query.
Share

Opens the Upload Query to Data Miner Repository screen, allowing you to upload the selected query to the Data Miner Repository.

Note:  This button will only appear if the Upload Queries to Data Miner Repository switch is activated in security system 505.

Clear Deletes all the virtual fields that have been added to query.
Close Closes the Virtual Fields tab without saving any changes.