# 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.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfU9tcCG6Wh2szS3e71YkQYZoo311yUply5PvZxBv2hvuJIBYAUSIl5cd0AV9TD7nybXZ2YMUUkn5KfIrdimUv_crdsxZakkE8bB2cx9RQinyKVrRFRXwuelDr9bJqnIyg-bJg6Bg?key=Rty2J-Nvu52MmQEiULqkYQ" alt=""><figcaption></figcaption></figure>

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

**Overview of critical functions and features offered by the Query Sheet:**&#x20;

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.<br>

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.

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXc9VQyoW_PUacP62jok4YeiYaOpTvKkAJuOuZIUs_pmDNRwHZ-EW0O4ff84cP19P4qbZepX4W-jdjWR9ltks9hN-KxZeWAkPHkQFcw8dGKc2X8gOvqqUnfp9ZKV5p_33QWEK9zYMA?key=9AmDK7scV0sp4TguGC9UhKss" alt=""><figcaption></figcaption></figure>

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. <br>

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.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfpalwcXiA5lPJUxfDyrNrrztwdBMWH1MAAJNvEIsPKmtJVnSfINK7meC64HW3z-883wGNP_CT4pETDWlnbD0WGfol9lYZM8WbuIo-_8nAUvziCeEe0blMYGNFa_8iC14_GZkH_vA?key=Rty2J-Nvu52MmQEiULqkYQ" alt=""><figcaption></figcaption></figure>

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/query-sheet/about-query-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.