How to Edit a Simple Query
StepsSelect a query from the list on the Query List screen
Click Edit. The selected Simple Query screen displays.
Make changes to the Simple Query screen by navigating through the tabs
and entering your changes as you would for creating a simple query .
Save or run your changed query.
Creating and Running Advanced Queries
You must have previous experience writing SQL queries to use this feature of
the accounting and reporting console.
How to Create an Advanced Query
StepsClick New Advanced Query on the Query List screen.
Enter your SQL query in the text box. This is the only difference
compared to the actions available for the Simple Query.

Save or run your query. To save your query, click Save.
To run your query, click Run.
How to Run an Advanced Query
Step How to Edit an Advanced Query
StepsSelect a query from the list on the Query List screen
Click Edit. A completed version of the Advanced Query screen
displays.
Make changes to the SQL query.
Save or run your changed query. To save your changed query, click Save.
To run your changed query, click Run.
Latebindings for Advanced Queries
The syntax for the latebindings in advanced queries is:
LATEBINDING{ <column>;<operator>;<default value> }
<column> name if the latebinding
<operator> a SQL operator (e.g. = < > in .. )
<value> default value (e.g. 'localhost' )
|
Example 5-7 Latebindings Examples
select hostname from sge_host where LATEBINDING{hostname, like, 'a%'}
select hostname from sge_host where LATEBINDING{hostname, in, ('localhost', 'foo.bar')}
|
|