VU CUSTOM
User Guides
User Guides
  • Getting Started
    • Overview
    • Getting Started
    • Product Visualization
      • 2D Guidelines
      • 3D Guidelines
    • Product Matrix
    • Next Steps
  • 🏂Onboarding
    • Implementation Overview
    • Setup E-Commerce Store
      • Shopify setup
    • Embedding the VU Customizer
    • Styling the Customizer
  • Customizer Admin
    • Overview
    • *Templates
    • 🚀Starting Points
    • Colors
    • Color Palettes
    • Font Library
    • Image Library
    • Elements
    • Embroidery Fonts
    • Embroidery Designs
    • Product Management
      • Products
      • Upcharges
  • VU Admin Platform Management
    • *Accessing VU Admin
    • Locales
    • Profanity Filter
    • Stores
    • Manage Announcements
    • User Management
      • Manage Roles
      • Create and Manage Users
  • Production
    • *Viewing Orders
    • *Order Travelers
    • *Factories
    • *Order Routing
    • Connections
    • *Managing Orders with VU's OMS
  • Reporting
    • *Query Builder
    • Reports
    • Operational Dashboard
    • Dashboards
  • Glossary
    • Glossary
Powered by GitBook
On this page
  1. Reporting

*Query Builder

Previous*Managing Orders with VU's OMSNextReports

Last updated 2 months ago

Query Builders enables brands to build reports based on their requirements. These query builders are used to fetch the reports for your dashboards.

Only users with Administrator permissions can add the query builders.

Add a New Query Builder

To add a query builder:

  1. From the Dashboard, click Settings > Query Builders > Add New.

  2. Enter the details provided in the table below as a reference:

    Field
    Description

    Name

    Name of the factory.

    Tables

    Select the query tables.

    Choose Columns and Alias

    Choose the column to build the query.

    Alias

    Alternate name for the column.

    Aggregate Function

    Select the function to perform in the query for the selected tables and columns.

    Distinct

    Select this checkbox to bring in different and unique values.

    Group by

    Select the

    Order by

    Select the option to order the queries.

    Limit

    Set the maximum number of query builders you can filter.

  3. Click Save.

The query builder will be successfully created.,

To edit a query builder, select the query and update the values.

To delete a query builder, select the query builder and click Delete. The query builder gets deleted after confirmation.