With Query Builder, an administrator can have the flexibility
to perfom a query using easy tool to display records. This tool also allows the
administrator to save their own created query for a table and load the queries
when editing a table.
Query Builder can be found in theVPCART Control
Panel :Misc >Query & Export
To create a query, choose a table
from the Selections dropdown menu. A list of fields from the selected
table will then be displayed at the right side of the dropdown menu.
You
can choose to select All or only select the needed fields. In the example below,
we selected Products table and choose “All” to display all fields. See the
screen below:
If
you need to filter out records based on criteria, you can use the criteria
options.
For example, you want to display product records that a have price
of $100,then your criteria will be something like the one shown on the screen
below:
Click Run query to display the result of the
query.
Click Save Query – New to save the query as a new
query.
Click Load Query to load all previous saved queries from the
selected table.
If you want to replace an existing query of a table with a new one, click Load Query and choose the query you want to load, then modify the query in the editor and click Save Query – Existing.