# 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="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FH17a1hstuV2E7feIF5G4%2Fquery_builder_1.png?alt=media&#x26;token=a4b09354-5a83-4af1-94ff-318148be83b1" 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="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FarY85gS62tKuC8fthCnw%2Fquery_builder_2.png?alt=media&#x26;token=a75e066e-8d72-4f6b-9573-e07411ed74a7" alt=""><figcaption></figcaption></figure>

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