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.
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  
The text editor appears in Query, as shown in Figure 2-44.
Figure 2-44  
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.

Additional Links:

Copyright Actuate Corporation 2012