Query Editor

A query is a request for data or information from a database table or combination of tables. We use SQL queries to request or collect data from the Datasource. The result of these queries is the request data, such as pictorials, graphs or complex results. This section covers creating SQL queries in Infoveave for widgets, reports, workflows, and activities.

Steps to Write, Execute, & Analyze Queries

Access Queries and Select Datasource

Streamline the process of formulating queries over existing Datasources in Infoveave to efficiently customize, analyze, and modify data, deriving meaningful insights from complex datasets.

1. To write a query in Infoveave over any existing Datasources, click on Studio Queries. All Queries, created by you or shared with you will be displayed under the tabs My Query and Shared Query respectively.
2. To formulate a fresh formula, click on New Query.
3. Select the Datasource you want to use from the drop-down list and click Continue.

Tip

Queries with the Production tag indicate that they are linked to a workflow in production.

Note

You can now use any column from the dataset in your query without specifying it as a measure or dimension in the Datasource.

Write, Execute & Analyze Queries

Write and execute queries over Datasources for precise data selection, filtering, and aggregation, ensuring a targeted focus on relevant information. This process facilitates informed decision-making through valuable insights into data patterns and trends.

1. After selecting the Datasource, write the required query in the editor box.
2. Click to execute the query.The viewer box displays the query results as in a tabular form.
3. Change the result visualization from tabular form to widget by selecting the Visualize tab, and the required widgets.
   • The measures and dimension will be defined by default.
   • Change the predefined measures and dimension with simple drag and drop feature to customize the widget visualization.
   • You can also change the widget type by selecting the widget from the list of available widgets.
   • Click on Save Widget to save the visualization to be used in the Infoboard
     • Name the widget saved.
4. View the Query Run History from the History tab
5. After executing the query, click on Save if you wish to save the SQL query.Save it either as a new query or as an update to the existing query.
6. Retain it as a new query with Save as New option, provide a query name and click Save.
7. To update an existing query, select Update Existing option. Enter the query name that requires updating and click Save.

Caution

To apply date or dimension filters when downloading a data report, the query must contain date and dimension filters.