User Query

User Query enable user to define a query to retrieve the data from the database using SQL statement and export the result to an Excel File or output to a Grid.

User Query can be created by applying a SQL query or save it from Report Control.

User Query can view your self created queries only unless you have Full Right or Full Function Rights (except User/Group Maintenance) defined in User Maintenance. In these case, you can view and maintain all queries created by other users.



Click the "+" button to add a new query
Highlight and click the "-" button to delete an existing query
Highlight and click the item in Description to redirect to Report Control Page for conditions selection and output either to Excel or Grid.

The query is similar to the query used in Business Alert. See Business Alert/User Query Samples

For Desktop Client, read How to execute user query?