Table below describes all available queries, the type of data each returns, and the supported data provider.
| Query | Description | OLE DB | ODBC |
|---|---|---|---|
| entity |
A basic query to test your data connections, returning default metadata about each entity. (Does not support parameters.) |
Yes | Yes |
| entity_name (entity_ID) |
Each entity in your repository corresponds to a query which, when run, returns data and metadata from that entity only. Refine the view returned by using one or more of the following entity tables: nview_name=’view_attribute_null_values_rows’nview_name=’view_br_fail’ nview_name=’view_entity_fail’ nview_name=’view_rows‘ |
Yes | |
| show_all_br | Retrieves data equivalent to that displayed in a List View of all
enabled business rule results. Includes business rule category,
subcategory, and priority metadata. Attribute ID metadata is returned
for entity business rules (attribute business rules display 0 (zero) for
the attribute ID value). For entity business rules in the Library, the
ID values of library attributes contained in the associated library
entity are returned. If no parameters are included, all columns for all enabled attribute and entity business rules are returned. |
Yes | Yes |
| show_attribute_names |
Retrieves the names of one or more attributes contained in one or more entities. Specify one or more entity IDs to return, otherwise the query will return an error. |
Yes | Yes |
| show_attribute_trend |
Retrieves attribute metadata for all entities in one or more specified Time Series Analysis projects. By default trend metadata will be returned for all attributes in all entities in all Time Series Analysis projects. |
Yes | Yes |
| show_baseline |
Retrieves data equivalent to that displayed in a List View of all Baseline Analysis projects in the repository. |
Yes | Yes |
| show_br_groups |
Retrieves data equivalent to that displayed in a List View of all
business rule groups for an entity. Specify one or more entities by
adding an entity, Baseline Analysis, or Time Series Analysis ID
parameter. If only one entity is specified, you can display the
groups for a single rule by specifying the rule’s ID.
Note: Group metadata is returned for only those
rules that have been both enabled and analyzed in the Control
Center.
|
Yes | Yes |
| show_br_metadata |
Retrieves business rule category and keyword (subcategory) metadata. |
Yes | Yes |
| show_entity_member _attributes |
Retrieves data equivalent to that displayed in an Entity Member Attributes List View for all attributes in the repository or in specified entities. |
Yes | Yes |
| show_entity_metadata |
Retrieves data equivalent to a subset of that displayed in an entity List View. By default, returns data for all entities in the repository. |
Yes | Yes |
| show_entity_names |
Retrieves the name of one or more entities specified by entity ID. Specify one or more entity IDs to return, otherwise the query will return an error. |
Yes | Yes |
| show_entity_trend |
Retrieves entity metadata for entities in one or more specified Time Series Analysis projects. By default all trend metadata will be returned for all entities in all Time Series Analysis projects. |
Yes | Yes |
| show_failing_br |
Retrieves metadata for failing entity business rules for one or more entities. |
Yes | Yes |
| show_project |
Retrieves data equivalent to that displayed in a Time Series Analysis or Quality project List View. |
Yes | Yes |
| show_project_failing_br |
Retrieves metadata for failed entity business rules for all entities associated with a Baseline Analysis or Time Series Analysis project. (Does not support parameters; all failing entity business rules for all entities in all Baseline and Time Series projects will be returned.) |
Yes | Yes |
| show_project_membership |
Retrieves entity ID metadata for all entities contained in Time SeriesAnalysis and Quality projects. |
Yes | Yes |
| show_tsq_project_names |
Retrieves the Trillium Quality project name associated with one or more entities. Specify one or more entity IDs to return, otherwise the query will return an error. |
Yes | Yes |
| TS_test |
A basic query to test your data connections. Returns five rows of data. (Does not support parameters.) |
Yes | Yes |
| view_attribute_decimal _values |
Retrieves decimal values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_distinct _values |
Retrieves distinct values data for a specified attribute. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_attribute_integer _values |
Retrieves integer values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_null_values _rows |
Retrieves rows where the attribute value is null. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_attribute_string _values |
Retrieves string values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values |
Retrieves data equivalent to that displayed in the List View for a specified attribute value. Add parameters to specify the type of attribute value data to return. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_attribute_values _discovered_dependencies |
Retrieves discovered dependency values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _discovered_joins |
Retrieves discovered join values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _discovered_keys |
Retrieves discovered key values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _mask |
Retrieves mask values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _metaphone |
Retrieves metaphone values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _pattern |
Retrieves pattern values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _permanent_dependencies |
Retrieves permanent dependency values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _permanent_joins |
Retrieves permanent join values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_attribute_values _permanent_keys |
Retrieves permanent key values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_attribute_values _soundex |
Retrieves soundex values for a specified attribute in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_br_fail |
Retrieves data equivalent to that displayed in a List View of failing rows for a specified entity business rule or attribute business rule in a specified entity. Supports fully-loaded, real entities and dynamic entities. |
Yes | |
| view_entity_fail |
Retrieves failing rows for entity business rules in a specified entity. Supports fully-loaded real entities and dynamic entities. |
Yes | |
| view_entity_values |
Retrieves data equivalent to that displayed in a Keys, Dependencies, or Joins List View for a specified entity value. Add parameters to specify the type of entity value data to return. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_entity_values _discovered_dependencies |
Retrieves discovered dependency values in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_entity_values _discovered_joins |
Retrieves discovered join values in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_entity_values _discovered_keys |
Retrieves discovered key values in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | Yes |
| view_entity_values _permanent_dependencies |
Retrieves permanent dependency values in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_entity_values _permanent_joins |
Retrieves permanent join values in a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. 100 rows are retrieved unless the max_rows parameter is used. |
Yes | |
| view_entity_values _permanent_keys |
Retrieves data equivalent to that displayed in a List View for permanent key values for a specified entity. Supports real entities that have been fully-loaded and analyzed; dynamic entities are not supported. |
Yes | |
| view_notes |
Retrieves all existing notes in the repository. (Does not support parameters.) |
Yes | Yes |
| view_rows |
Retrieves data equivalent to that displayed in the List View for a specified entity. 100 rows are retrieved by default if the max_rows parameter is not used. All available columns are returned. |
Yes |