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.
Access query 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.
Write, execute and analyze 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.
Save query Save the executed SQL query to enhance reproducibility, support adaptability to new data analysis needs, and for report generation.
Search
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 View
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 Queriess. This layout provides a more visual representation of the Queriess and folders, making it easier to identify and organize items.
List View
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.
New Folder
To organize your items and Queriess more efficiently, you can create a new folder. Here’s how to do it
Click the New Folder button, this 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 or contents, such as “Reports” or “Financial Data.”
After entering the folder name, click the Save button to create the folder. The new folder will appear under Folders section.
Export Query List
The Export Query List feature allows users to download a structured file containing all available queries within the system.
New Query
When you click on New Query, a popup window appears, prompting users to choose between two query creation methods: Query Editor and Query Builder.
Users must also select a Datasource before proceeding. Once a method and Queries are chosen, clicking Continue advances to the next step, enabling query creation and execution.
Filter 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.
Filter 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.
