Go to documentation repository
Page History
The user can create and edit queries in the receipts database. This is an optional function in addition to system setup.
Warning! The user query in the Receipt viewer window will be created and processed, only if the receipts parser has been set up (see the Setting up the parser (optional) section).
Query editor provides the following functions:
- Creating and editing the list of queries. The parameters can be imported from a text file (POS query file) or using the built-in functions.
- Search for a query in the list
- Export query parameters into a file or other Receipt viewer objects.
...
- Click the Import button.
Open a query file in the standard Windows file open dialog box.
Info title Note. We recommend importing the list of queries from the <Axxon <Axxon PSIM program folder>\Modules\queries_eng.txt file included in the Axxon PSIM installation kit. 
- If the file loads successfully, the list of available queries will be displayed in the Query list area.
...
The table shows the interface elements of the Query editor window.
No | Element name | Element type | Description | Data type | Default value | Value range |
1 | Query list | List, items imported or edited using the editing buttons | List of queries | Names of existing queries | - | Depends on the number of existing queries |
2 | Hide | Checkbox | Hides the query in the Receipt viewer window | Boolean | No | Yes |
– the query is not displayed in the Receipt viewer window. No – the query is displayed | ||||||
3 | Query text | Text field | The text of the query | SQL language | - | - |
4 | Parameters | Text field | Query parameters | SQL language | - | - |
5 | This is a slave query | Checkbox | Makes the query a slave | Boolean | - | Yes – the query is a slave. No – the query is not a slave |
6 | Slave query | Drop-down list | The query which is a slave relative to this query | Names of existing slave queries | - | Depends on the number of existing slave queries |
| Info | ||
|---|---|---|
| ||
Use SQL templates while editing the text of the query. Click the Macro button and select an item from the list that opens (Figure 6.5—24). |
...
To search for queries in the Query list, do the following
...
| Info | ||
|---|---|---|
| ||
| Use the Copy and Paste buttons to copy the query list to other Receipt viewer windows. |
To save changes and close the Query editor window, click OK.
The query editing in the Receipt viewer window is complete.
Overview
Content Tools