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

Notice: 'Query builder' section only accepts "select" commands, user (administrators and regular operators) cannot update or delete data from this window.

If the query is correct, result will be displayed as shown below.

Notice: for more information about custom reports contact your P4W official reseller.