Edit tab

Excel > CCH® Tagetik > Design > (Left-hand panel) click form > > Query

See How to access the windows for alternative paths.

Purpose of the tab¶

This tab allows you to define the type of query and the text of the query in SQL language.

Buttons for managing the query

Element	Description
	Advanced fields. Insert a cell field into the query (see Cell fields). This allows you to define parametric queries to be filtered according to the content of the form and the parameters chosen when it is run.
	Syntax check. Checks that the query syntax is correct.
{ }	Insert cell fields container. Adds the { and} symbols to the text box, as required to contain a cell field.
	Import query from a shared table. Imports a previously defined query into the database as a shared query. The imported query will appear in the window and can be edited. When the imported query is changed from the query in the table, its structure will be saved in the form.
	Import query as link from a shared table. Imports a link to a query previously defined in the database as a shared query. The query imported as a link will appear in the window as ${query:QUERY_NAME}. Therefore, the body of the query cannot be edited and will not be saved in the form.
	Export query to a shared table. Exports the defined query to share it with other users. To export it, a code and a description must be specified. Once shared, the query can be used in drill down.
	Save changes to the {QUERY_NAME} query. Saves the changes defined on the selected query in the shared table.

Query structure conventions

The following conventions are applied within the query text: