Skip to content
Infoveave Help

Query Editor

A query is a request for data or information from a database table or a combination of tables. SQL queries are used to retrieve or manipulate data from the datasource. The results of these queries can be visualized as charts, graphs, or complex datasets. This section explains how to create SQL queries in Infoveave.

Creating Queries using Query Editor

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 Queries and Shared Queries respectively.
  2. To formulate a fresh formula, click on New Query button. query editor box
  3. Select Query Editor box.
  4. Select the Datasource you want to use from the drop-down list and click on Continue button. query editor
  5. Write the required query in the editor box.
  6. Click to execute the query. The viewer box displays the query results as in a tabular form.
  7. Viewing the query run history from the History tab
  8. 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.
  9. Retain it as a new query with Save as new option, provide a query name and click Save.
  10. To update an existing query, select Update existing option. Enter the query name that requires updating and click Save.