Note the following when working with queries:
-
The Trillium queries are built into the Trillium software byte-compiled tbc code.
-
Queries support both real and dynamic entities, unless otherwise noted.
-
Queries support both data providers, unless otherwise noted.
-
When you run a query most (in some cases all) available columns are returned unless you specify which columns and row data are to be returned. For information about query columns, see Column Names.
For information about query syntax and how to add parameters, see Adding Parameters to Queries.