Creating a textual information object query

Use the Actuate SQL text editor if either of the following conditions is true:

Information Object Query Builder does not generate the desired Actuate SQL query, so you must edit the query. For example, a query that includes OR or UNION requires using the Actuate SQL text editor to edit the query.

You can type or paste an Actuate SQL query and not use the graphical editor.

Saving a query in the Actuate SQL text editor, prevents further modifications to the query using the graphical editor.

To open the Actuate SQL text editor in Query, choose SQL editor, as shown in Figure 2-43.

Figure 2-43

Opening the SQL text editor in Information Object Query Builder

The text editor appears in Query, as shown in Figure 2-44.

Figure 2-44

Editing an Actuate SQL query using the SQL text editor

You edit the query text that appears in Query. When editing a query in the SQL text editor, do not use table and column aliases that are identical except for case. For example, do not use both status and STATUS as column aliases.

Use paths that are relative to the resource root in the textual query editor.

Copyright Actuate Corporation 2012