Create a Query Group | Teradata Viewpoint - Creating a Query Group - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
Create a query group in the Query Group Setup portlet to allow users to view their most relevant queries in the Query Groups. You create a query group to filter the queries that are displayed and limit the users that have access to the group.

Enabling the Dictionary data collector in the Monitored Systems portlet makes sure the lists of usernames in the Access tab is current.

  1. Select a system from the Systems list.
    A system cannot be changed after you create a query group.
  2. Select the Add Group "" button.
  3. Enter a Query group name, up to 30 characters.
  4. [Optional] Enter a Description, up to 256 characters.
  5. For the This group contains queries with attributes that match at least one value in field on the Criteria tab, do one of the following:
    • Select Every criteria below to match at least one value in each defined sub-tab. Criteria on each sub-tab are joined by AND.
    • Select Any criteria below to match at least one value in one or more of the defined sub-tabs. Criteria on each sub-tab are joined by OR.

      Query Group Setup portlet: create a query group

  6. Select a criterion from the Add Criteria list.
  7. Select values for whichever criteria you chose:
    Criteria Select values by doing any of the following:
    Account String

    Username

    Workload Name

    • In the Match string box, enter a value to reduce the number of available values.
    • Select a value from the Available box then select "" to move it to the Selected box.
    • In the Match string box, enter a value to create custom criteria, then select "" to move it to the Selected box. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    Query Band
    • Select a Query band name from the list and a value from the Available Values box, then select "" to move them to the Selected box.
    • Enter a Custom Query band name and value pair, then select "" to move them to the Selected box.
  8. In the Access tab, designate the users who can view the group by doing any of the following:
    • In the User List Filter box, enter a value to reduce the list of available users. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    • In the Available Users box, select one or more Viewpoint users and click "" to move them to the Selected Users box.
    • In the Available Roles box, select one or more Viewpoint roles and click "" to move them to the Selected Roles box.
  9. [Optional] Select Reset to clear the query group name, description, and the selections on the Criteria and Access tabs.
  10. Click Apply.