Widgets

A widget is an element of a graphical user interface (GUI) that displays information or provides a way for a user to interact with the warehouse management system.

P4W widgets combine SQL queries with visual tables and charts to provide easy access to the key information about warehouse.

Navigate to Setup > Reporting > Widgets. From the widget list page users can access existing widgets and create new one.

Create New Widget

To create new widget, click 'New' button in the top right corner.

In the 'New widget' pop-up window, enter name and description of the widget. Click 'Submit' to continue.

Notice: 'Name' field is mandatory for filling.

From the widget list page, click on the link of newly created widget to open widget details page.

SQL Query

Add the new query to the corresponding field as shown below.

Click 'Execute' button to make sure your query is working as intended.

Widget Visualization

To add graphical representation of data, click 'plus' button as shown below and select.

P4W widgets visualization include : Chart, Grid, and Scalar (singular number). Select the desired visual type and set them according to your needs.

Chart

Grid

Scalar

Click 'Update' button in the top right corner to save changes.

Notice: KPI's are an in-depth subject; it is recommended you speak with your P4Warehouse official reseller to get more details.

Import Widget

To import an existing widget, click 'Import' button in the top right corner and upload a JSON file containing new widget from your local machine.

Export Widget

To export an existing widget in a JSON file format, click 'Export' button from the action column next to the chosen widget.

Delete Widget

To delete a widget, select it with the check box mark and click 'Delete' button as shown below.

Notice: contact your P4W official resellers to inquire about custom reports.