Documentation for POS PSIM 1.0.1.

Previous page Setting up the Receipt viewer window display  Setting up the Shop system object Next page

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:

  1. 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.
  2. Search for a query in the list
  3. Export query parameters into a file or other Receipt viewer objects.

Creating and editing the list of queries

Opening the Query editor

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

Importing a query from a text file

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

  1. Click the Import button.

  2. Open a query file in the standard Windows file open dialog box.

    Note

    We recommend importing the list of queries from the <Axxon PSIM program folder>\Modules\queries_eng.txt file included in the Axxon PSIM installation kit.
  3. If the file loads successfully, the list of available queries will be displayed in the Query list area (1).

The query file import is complete.


Adding a query to the Query list

To edit queries, use the editing buttons (2).

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

  1. Click the “+” button (1).
  2. Enter a name for the query in the dialog box that opens (2).
  3. Click OK (3).

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


Editing a query name in the Query list

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

  1. Select a query in the Query list (1).

  2. Click the “…” button (2) or double-click the query name (1).

  3. Enter a new name for the query in the dialog box that opens (3).
  4. Click OK (4).

The query name will be changed.


Removing a query from the Query list

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

  1. Select a query in the Query list (1).
  2. Click the “-“ button (2) or right-click the query name (1) to open the drop-down menu and select the Delete option.

The query will be deleted from the list.

Displaying a query text

To display a query text, select its name in the Query list (1).

The query contents are shown in the Query text area (3).

Interface of the Query editor window

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

Deny

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 subquery

Checkbox

Makes the query a slave

Boolean

-

Yes — the query is a slave.

No — the query is not a slave

6

Subquery

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

Use SQL templates while editing the text of the query. Click the Macro button (1) and select an item from the list that opens (2).

Searching for queries in the Query list

To search for queries in the Query list, do the following:

  1. Enter the word to find in the Substring field (1).
  2. Click the Select button (2).
  3. The query names containing the word will be highlighted in the Query list (3).

The search for queries in the Query list is complete.

Export the query parameters into a file or other Receipt viewer objects

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

  1. Click the Export button (1).
  2. Save the query file in the standard Windows file save dialog box.
  3. To save changes and close the Query editor window, click OK (2). 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.

The query editing in the Receipt viewer window is complete.

  • No labels