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 We recommend importing the list of queries from the <Intellect program folder>\Modules\queries_eng.txt file included in the Intellect installation kit. 
- If the file loads successfully, the list of available queries will be displayed in the Query list area.
...
- Select a query in the Query list
Click the “…” button.
Info title Note. Or double-click the query name instead of clicking the “…” button. - Enter a new name for the query in the dialog box that opens.
- Click OK.
...
The query will be deleted from the list.
| Info | ||
|---|---|---|
| ||
| A query can be also deleted by right-clicking the query name to open the drop-down menu and selecting the Delete option. |
...
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
...
Query export is complete.
| 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.