|
|
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.
|
|
ART 