About Query Sheet

The Query Sheet helps to build, summarize, save, and execute queries according to business needs. The Query tool enables quick query operations, including aggregation, dataset joining, union creation, data grouping, sorting, and filter application.

The Query Sheet is a versatile tool for efficient data management and analysis.

Overview of critical functions and features offered by the Query Sheet:

1. Access Data from OvalEdge Repository Tables: The Query Sheet enables authors with data write permission to access data stored in the OvalEdge repository tables seamlessly. This access is facilitated through the Query window, which provides a gateway to valuable datasets.

2. Streamlined Query Operations: The query sheet introduces shortcut operations to perform filtering, aggregation, Sorting, Joining, and Grouping, making data manipulations easier and more efficient.

   

3. Query Execution and Saving: The Query Sheet enables users to perform queries, execute them within the Ovaledge query sheet, and save the executed code in the Data Catalog for future reference.

4. Cataloging and Sharing of Saved Queries: Saved queries can be cataloged, making it easier to organize and locate specific queries. Furthermore, the Query Sheet supports sharing saved queries, facilitating collaboration and knowledge transfer.

Navigation

To access the Query Sheet, conveniently locate it on the left panel menu.

The Four Key Sections of the Query Sheet are:

1. Object Explorer: This section provides an Object Explorer, a vital tool for selecting and exploring the contents of data objects. It allows for navigating databases, schemas, tables, and other data repositories and is a comprehensive data directory.

2. User Interactive Function Menu Bar: The Function Menu Bar is a user-friendly and interactive control center for query operations. It simplifies executing essential query tasks such as filtering, aggregating, sorting, and more. While using this menu, specific options may appear disabled, indicating they can be activated after certain conditions are met.

3. Query Editor Window: The Query Editor Window allows manual query composition and advanced operations. Writing queries and fine-tuning the logic allows us to explore advanced capabilities. Access to this window is swift through a keyboard shortcut (CTRL+Q), improving the experience.

4. Result Window: The Result Window provides a platform to view the outcomes of their executed queries. It displays query results, effectively examining and interpreting the data.