Queries are SQL scripts used to pull data from Blaq into a template.
A query is made up of a number of different parts, but it works very much like an SQL script. They should only be created or modified by someone familiar with SQL.
As well as normal database fields, there are a few calculated fields in Blaq used to simplify scripting. They are:
- [F:Component_Tax] - the tax on the current component.
- [F:Component_Price] - the price for a single unit of the current component.
- [F:Component_Quantity] - the total quantity ordered for the current component.
- [F:Component_Nett] - the nett price for the current component.
Last modified: 1/07/2009