| Note | ||
|---|---|---|
| ||
As of July 25th, 2023, there is a content freeze on this page. |
Specifies an SQL statement to use to retrieve the records for a chart, including maps.
...
The query above would produce a chart with product names (PNAME) as labels and prices (PPRICE) as values.
| Code Block | ||
|---|---|---|
| ||
SELECT PNAME, PCNAME, PSTOCK FROM PUISAMPLES/PRODP |
The query above would produce a chart with produce names concatenated with category names (without spaces between the fields), and stock numbers (PSTOCK) as values.
| Code Block | ||
|---|---|---|
| ||
SELECT PNAME || ' ' || PCNAME, PSTOCK FROM PUISAMPLES/PRODP |
...