The following is the default syntax for queries used with the ODBC Reporting Adapter:
SELECT * FROM "SCHEMA"."user_name"."query_name"
Entity queries (queries associated with entities in the repository) have the following syntax:
SELECT * FROM "SCHEMA"."user_name"."entity_name(entity_id)"
Where
SELECT signifies that this type of SQL statement is a query.
* specifies that all columns and rows be returned by default.
FROM "SCHEMA". SCHEMA is the default name of the repository database and FROM instructs the query to extract data from it.
"user_name" is the name of the owner of the query (the user who created the query) in double quotes (“”).
"query_name" is the name of the Trillium query you are running. The double quotes around the name are optional.
entity_name(entity_id) is the name and unique reference/object ID number for the entity.
For example, the default syntax for "show_all_br" owned by OAUSER is:
SELECT * FROM "SCHEMA"."OAUSER"."show_all_br"