Introducing Queries

Use SQL queries to retrieve, manipulate, and manage data stored in relational databases. SQL (Structured Query Language) is used to perform various operations like fetching data, updating records, deleting records, and creating or altering database structures.

Within this guide, you will find three sections, each focusing on a specific aspect of working with queries in Infoveave

Query Editor

The Query Editor in Infoveave allows you to write and execute SQL queries over various Datasources. You can connect to multiple Datasources, write standard SQL queries, and instantly view results. The editor supports advanced features like JOIN operations, aggregation functions, and subqueries, making it an essential tool for efficient data retrieval, manipulation, and analysis.

Query Builder

The Query Editor in Infoveave is a UI-driven tool designed for writing and executing SQL queries over various Datasources. It offers a user-friendly interface where you can drag and drop columns, apply filters, perform operations such as JOIN operations, aggregation functions, and set conditions without needing extensive SQL knowledge.

Infoveave Query Functions

Infoveave SQL Query functions provide both business and custom calendar date functions for SQL queries, accepting parameters for Date, Level, and Lag. The Date can be @Start-Date, @End-Date, or @Current-Date in “YYYY-MM-DD” format. Level specifies date granularity (Years, Quarters, Months, Weeks, Days), and Lag is an integer for adjusting the date.

Manage Queries

The “Manage Queries” feature provides comprehensive control over your SQL queries allowing you to organize, customize, and share them efficiently. The Queries can be managed with the options to Show as Report, Edit, Share, Move to Folder, Add Description, and Delete.