Query Template
  • 05 Oct 2023
  • PDF

Query Template

  • PDF

Article summary

This information is specific to the latest release of PARCview:

7.2.x


Use the query template tab to view and create generic SQL script templates that can be used by various PARCview displays. These templates are generally used for overriding a process area’s source of grade, product, filter, and tag limit information. For example, Centerlines can use a query template to retrieve grade run information instead of using a grade tag. Templates can be created and tested here.


PARCSecurity Permissions

PARCsecurity Console should be configured for the following permissions for rights to System Configuration elements.

  • DataPARC Admin: Grants administrative access to PARCview.
  • System Config Process Area: Grants access to the Process Area tab in System Configuration.
  • System Config Process Tags: Grants access to the Process Tags tab in System Configuration.
  • System Config Reason/Evidence/Category: Grants access to the Reason, Evidence and Category tabs in System Configuration.


Configuration

Query Type: Query templates can be organized by query type. The query types are used in the Run Browser and MDE Configuration.

Query Template Properties: Name and DSN information for selected Query Template

Query Template Script: Enter the native script, with tokens in curly brackets to dynamically retrieve variable information.


Log Files

PARCMessage is a built-in error monitoring software. It creates an ongoing log of errors generated from PARCview on the specific computer where PARCMessage is running in the system tray. The Icon in the tray is a triangle, red if errors are present, and green if there are no errors.

Errors can also be stored in the PARCview install directory both on the server and clients ...\Capstone\PARCView\LogFiles.


Required Server Applications

No server applications are required to use System Configuration.

UA Server: All PARCview vr 7 functionality requires a Universal Access (UA) server.

GDS: All PARCview vr 7 functionality requires a Global Discovery Server (GDS).


Was this article helpful?

What's Next