Queries Toolbar
Need help
If you’re unsure about how to create a Queries in Infoveave, you can always get assistance by clicking the Need help button. Upon clicking the button, you’ll be directed to a visual walkthrough on how to create a Queries.
- Accessing query and selecting 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.
- Writing, executing and analyzing query 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.
- Saving query Save the executed SQL query to enhance reproducibility, support adaptability to new data analysis needs, and for report generation.
Searching
The Search Bar at the top-right of the screen allows you to quickly locate any Queries within the platform. Simply enter keywords related to the name of the Queries or any part of the content you’re searching for.
Card
When you click on the Card option in the layout filter, the items are displayed in a card-based view, which is the default layout for organizing Queries. This layout provides a more visual representation of the Queries and folders, making it easier to identify and organize items.
List
When you click on the List option, the layout changes to a table view, which displays the items and folders in a more detailed, structured format. This layout is ideal for users who prefer seeing data in rows and columns, allowing for quick access to information such as the item name, type, creation date, last update date, and more.
Creating New Folder
To organize your items and Queries more efficiently, you can create a new folder. Here’s how to do it
-
Clicking the New Folder button will open a popup where you can configure your new folder.
-
In the popup that appears, you’ll be prompted to enter a name for your new folder. Choose a name that helps you identify the folder’s purpose.
-
After entering the folder name, click the Save button to create the folder. The new folder will appear under Folders section.
Exporting Query list
The Export Query list feature allows users to download a structured file containing all available queries within the system.
Creating New Query
To learn about creating Query using Query Editor, visit Query Editor
To learn about creating Query using Query Builder, visit Query Builder
Filtering by type
The Filter by type feature allows users to refine their search by selecting a specific query type from the dropdown menu. In this case, the user can filter queries based on SQL, ensuring quick access to relevant queries without manually searching through the entire list.
Filtering by mode
The Filter by mode feature allows users to categorize and refine their search based on the query’s status. The dropdown provides two options- Draft and Production.
- Draft: Displays queries that are still in progress or under development.
- Production: Shows finalized queries that are actively used in operations.