Add Query
Query: On the Add Query page, you can set up a database query string, for example, in SQL. You use a query to select the data that comes from a data source.
|
1.
|
On the Name the Query page, enter a name and an optional description for the query. The resource ID automatically takes the name of the query; however, you can edit the ID. |
|
2.
|
Click Next to open the Link a Data Source page. You can link a data source to the query.- If you do not want to link a data source, select the Do not link a data source check box. XRA then uses the data source that is linked to the report that references this query.
- To link a data source to the query, select the Select data source from repository check box, and then click Browse to find it in the repository.
|
|
3.
|
Click Next to open the Define the Query page. |
|
4.
|
Select a query language from the list - SQL
- HQL (Hibernate)
- HiveQL (Hadoop-Hive)
- MongoDB Query
- Domain queries
|
|
5.
|
Enter a query string in the text box. |