ODBC Parameters Table - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2012

The Available Trillium Parameters for ODBC table describes each parameter (shown in alphabetical order), lists the queries that support the parameter, and gives syntax examples. The Available Trillium Parameters for ODBC, by Query table lists all queries in alphabetical order and the parameters they support.

Parameter Supported Queries Description Syntax Example
add_key

entity_name (entity_ID)

   view_name=’view_attribute_null_    

    values_rows’

  view_name=’view_br_fail’

  view_name=’view_rows‘

view_attribute_decimal_values

view_attribute_distinct_values

view_attribute_integer_values

view_attribute_string_values

view_attribute_values_discovered_   

 dependencies

view_attribute_values_discovered_joins

view_attribute_values_discovered_keys

view_attribute_values_mask

view_attribute_values_metaphone

view_attribute_values_pattern

view_attribute_values_permanent_     

 dependencies

view_attribute_values_permanent_joins

view_attribute_values_permanent_keys

view_attribute_values_soundex

view_entity_values_discovered_

 dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_

 dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

Include the attribute and entity ID column value data. Useful for maintaining referential integrity. “add_key”=’1’
aid

entity_name (entity_ID)   view_name=’view_attribute_null_values_rows’

show_attribute_names

view_attribute_decimal_values

view_attribute_distinct_values

view_attribute_integer_values

view_attribute_string_values

view_attribute_values_discovered_

 dependencies

view_attribute_values_discovered_joins

view_attribute_values_discovered_keys

view_attribute_values_mask

view_attribute_values_metaphone

view_attribute_values_pattern

view_attribute_values_permanent_   

 dependencies

view_attribute_values_permanent_joins

view_attribute_values_permanent_keys

view_attribute_values_soundex

List of one or more attribute IDs from which to retrieve the view. “aid”=’1’; “aid”=’1 2’

baseline

show_baseline List of one or more Baseline Analysis project IDs. “baseline”=’5’; “baseline”=’6 7 8’
ebr

entity_name (entity_ID)

  view_name=’view_br_fail’

The ID of the business rule for which you want to see failing rows. This ID is the Sequence Number attribute in the Control Center. “eid”=’1’ AND “ebr”=’12’
  show_br_groups When a single entity is specified, use this optional parameter to display groups for the specified rule only.  
eid

entity_name (entity_ID)

   view_name=’view_attribute_null_         

      values_rows’

  view_name=’view_br_fail’

  view_name=’view_entity_fail’

  view_name=’view_rows‘

show_all_br

show_attribute_names

show_br_groups

show_br_metadata

show_entity_member_attributes

show_entity_metadata

show_entity_names

show_failing_br

show_tsq_project_names

view_attribute_decimal_values

view_attribute_distinct_values

view_attribute_integer_values

view_attribute_string_values

view_attribute_values_discovered_

 dependencies

view_attribute_values_discovered_joins

view_attribute_values_discovered_keys

view_attribute_values_mask

view_attribute_values_metaphone

view_attribute_values_pattern

view_attribute_values_permanent_dependencies

view_attribute_values_permanent_joins

view_attribute_values_permanent_keys

view_attribute_values_soundex

view_entity_values_discovered_dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

List of one or more entity IDs from which to retrieve the view.

“eid”=’1’; “eid”=’1 2’

generations

show_all_br

show_br_groups

show_br_metadata

show_entity_member_attributes

show_entity_metadata

view_entity_values_discovered_dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_

 dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

Use with the tsa parameter to indicate how many entity generations to retrieve:  

ngenerations=1: returns the newest entity (the latest entity generated in the project)

ngenerations=2: returns the 2 most recent entities

ngenerations=n: returns the n most recent entities

“tsa”=’5’ AND “generations”=’2’

max_per_rule

entity_name (entity_ID)

  view_name=’view_entity_fail’

Set the maximum number of rows to retrieve for each failing entity business rule. If no value is specified, the first 100 rows for each failing entity business rule are returned.

Use with the max_rows parameter to limit the total number of rows returned for all failing entity business rules. For example, ...WHERE view_name=’view_entity_fail’ AND eid=’1’ AND max_per_rule=’5’ AND max_rows=’1’ returns the first row for the first failing ebr.

Note: The max_rows parameter takes precedence over the max_per_rule parameter. ensure their values do not conflict.
“eid”=’1’ AND “max_per_rule”=’5’
max_rows

entity_name (entity_ID)

  view_name=’view_br_fail’

  view_name=’view_entity_fail’

  view_name=’view_rows‘

   view_name=’view_attribute_null_    

    values_rows’

view_attribute_decimal_values

view_attribute_distinct_values

view_attribute_integer_values

view_attribute_string_values

view_attribute_values_discovered_

 dependencies

view_attribute_values_discovered_joins

view_attribute_values_discovered_keys

view_attribute_values_mask

view_attribute_values_metaphone

view_attribute_values_pattern

view_attribute_values_permanent_

 dependencies

view_attribute_values_permanent_joins

view_attribute_values_permanent_keys

view_attribute_values_soundex

view_entity_values_discovered_

 dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_

 dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

Set the maximum number of rows to retrieve across the dataset. If no rows are specified, 100 rows are returned by default. “max_rows”=’500’
pid

show_all_br

show_attribute_trend

show_br_groups

show_br_metadata

show_entity_member_attributes

show_entity_metadata

show_entity_trend

show_project

view_entity_values_discovered_

 dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_

 dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

List of one or more Baseline Analysis project IDs. “pid”=’10 11’
proj_type show_project Set to Time Series Analysis (tsa or 1) or Quality (tsq or 2) to show only Time Series or Trillium Quality projects, respectively. When omitted,  the default is to return both.

“proj_type”=’tsa’: returns only values for Time Series Analysis projects

“proj_type”=’2’: returns only values for Quality projects

show_disabled show_all_br Return rules that are disabled. “eid”=’6’ AND “show_disabled”=’1’
tsa

show_all_br

show_br_groups

show_br_metadata

show_entity_member_attributes

show_entity_metadata

view_entity_values_discovered_dependencies

view_entity_values_discovered_joins

view_entity_values_discovered_keys

view_entity_values_permanent_dependencies

view_entity_values_permanent_joins

view_entity_values_permanent_keys

List one or more Time Series Analysis project IDs. Add the generations parameter to view a specified number of generations.

“tsa”=’5’; “tsa”=’2’ AND “generations”=’2’