> For the complete documentation index, see [llms.txt](https://docs.p4warehouse.com/v2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.p4warehouse.com/v2/reporting/scheduled-reports/query-tab.md).

# Query Tab

In the query tab, users can enter required query if the following field.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FaxiOksiPhBqaD3Rsns7X%2Fnew_scheduled_report_4.png?alt=media&amp;token=f5ce927a-277a-4bd0-bae5-c53909c74b5e" alt=""><figcaption></figcaption></figure>

To test your query and see the result, click execute button. If the query works correctly, results wil be displayed as shown below.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FqxEjP1JqZAhXwUalXo9V%2Fnew_scheduled_report_5.png?alt=media&amp;token=b52ba7af-c8e7-4315-8007-ac53c745181c" alt=""><figcaption></figcaption></figure>

#### Recurrence

In the recurrence sections, users can setup schedule and frequency for the current report. Use drop down menu to choose frequency. Available options are: Monthly, Weekly, Daily, Hourly.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FNMcHBS9ZHjl0PEremxtW%2Fnew_scheduled_report_6.png?alt=media&amp;token=6d336730-52c7-48b0-9444-5071829b9ee7" alt=""><figcaption></figcaption></figure>

After setting report frequency, add days and time for report execution. Click 'Add Day' button and select a day and time.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FSeMyqtPsQTIobIJvNKsb%2Fnew_scheduled_report_7.png?alt=media&amp;token=a8b44919-bfff-4202-a0af-2da2a4b78378" alt=""><figcaption></figcaption></figure>

Users can select multiple time slots per day.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2F0RNf5jAfYGPZOqW6UM0v%2Fnew_scheduled_report_8.png?alt=media&amp;token=43cbe426-0fc9-446c-b784-3c60c48f38d7" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Notice: Do not select the same day (Monday, Tuesday, Wednesday, etc.) twice. This action will cause an error and will prevent schedule report from execution. &#x20;
{% endhint %}

To remove day and time selection, click 'Delete' button next to the chosen position as shown below.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FLwJGlFVfzFGAG0axHUP8%2Fnew_scheduled_report_9.png?alt=media&amp;token=186b56c8-6017-4c80-b387-bb94f609ac03" alt=""><figcaption></figcaption></figure>

Click 'Update' button to save changes.&#x20;

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FuEcqE7DQmbcxUEWPVJ0v%2Fnew_scheduled_report_10.png?alt=media&amp;token=2b375045-88f2-4eb4-b27a-1cc7eac4e4cf" alt=""><figcaption></figcaption></figure>

To see the report's schedule, click 'Execution plan' button in the top right corner of the page.

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FvUWTU0ugxm7AnHqmqphr%2Fnew_scheduled_report_12.png?alt=media&amp;token=9334b73c-d880-4db2-9bbc-e3d5b9bbc660" alt=""><figcaption></figcaption></figure>

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FFYmDhBXttjzK0oCleGKk%2Fnew_scheduled_report_13.png?alt=media&amp;token=08c1d2ac-5c16-4dae-be63-461d1bbc6d8b" alt=""><figcaption></figcaption></figure>
