Editing the receipts database queries (optional)

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.

To open the query editor, click the Query editor button. The Query editor window opens.

To import a query from a text file, do the following:

Click the Import button.
Open a query file in the standard Windows file open dialog box.
Note.
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.

The query file import is complete.

To edit queries, use the editing buttons.

To add a query to the Query list, do the following.

Click the “+” button.
Enter a name for the query in the dialog box that opens.
Click OK.

The name of the new query will be added to the list.

To edit a query name in the Query list, do the following

Select a query in the Query list
Click the “…” button.
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 name will be changed.

To delete a query from the Query list, do the following:

Select a query in the Query list
Click the “-“ button.

The query will be deleted from the list.

Note.

A query can be also deleted by right-clicking the query name to open the drop-down menu and selecting the Delete option.

To display a query text, select its name in the Query list. The query contents are shown in the Query text 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

Note.

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

Enter the word to find in the Word field
Click the Find button.
The query names containing the word will be highlighted in the Query list.

The word search in the Query list is complete.

To export the query list into a file, do the following:

Click the Export button.
Save the query file in the standard Windows file save dialog box.
The user queries will be saved in the file.

Query export is complete.

Note.

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.

Page tree

Documentation for POS Intellect 5.3. Documentation for other versions of Intellect is available too.