|
|
Learn how to create an Art query in a few Screenshots
1. Login

Define a new datasource
2. In the Admin Console, click on Datasources button

and define connection parameters to your database

Define a new query
3. Back to the Admin Console, click on Object button to reach the Manage Object Console

4. Click on New and define a new query

This simple SQL code shows how to define parameters: just surround the label with #s. We set the Type attribute to get result in Tabular format.
5. Click on Commit to reach the Object Editor page

6. Click on Parameters button, then New to create the new parameter

in the example we defined a simple inline parameter. To show a list of parameters value, set use LOV to yes and select the query that gets the list.
That's all. From the admin console click on Users to create a new user and then on User Privileges to grant him the permission to run the query. See how parameter page and final layout looks like from the ScreenShots page.
Change the query type to Vertical Bar to plot a chart instead of a tabular result set. Have the user to set the View Mode to Document to get a PDF output or to Schedule to get the result in his mailbox at a given time.
|
|