> 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/system/query-builder.md).

# Query Builder

'Query Builder' provides users with an option to query data or create reports through the P4W web interface. 

To use this function, navigate to Setup > System > Query Builder.

Enter the query using TSQL programming language and click 'Execute'.

<figure><img src="/files/TrQTQobsv9yCnBFGqC8h" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Notice: 'Query builder' section only accepts "select" commands, user (administrators and regular operators) cannot update or delete data from this window.
{% endhint %}

If the query is correct, result will be displayed as shown below.&#x20;

<figure><img src="/files/77Pef2zn6lGRUprH7T2g" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Notice: for more information about custom reports contact your P4W official reseller.
{% endhint %}