Guidelines - trillium_discovery - trillium_quality - 17.1

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

Note the following:

  • The TOP and FROM clauses can be added to refine results (see Examples).

  • Do not remove any of the base elements of the query; add clauses, column names, and row values as needed.

  • Separate two or more column names with a comma and space and ensure they are entered before FROM.

  • Enclose column names and parameters in double quotes (“”); for example "aid" and "eid"='1' AND"show_entity_names"='5'

  • Enclose values values in single quotes (‘’); for example, "aid"='2'.

  • To return multiple entity, attribute, or project IDs, add the values with a space between each. For example, WHERE "eid"='1 2 3'

  • If you do not specify column names and rows, all available columns display for all rows. For information about columns returned, see Column Names.