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.