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’ |