Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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.

Image Modified

Importing a query from a text file

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

  1. Click the Import button.Image Removed
  2. Open a query file in the standard Windows file open dialog box.
    Image Added

    Info
    titleNote
    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.

    Image Removed


  3. If the file loads successfully, the list of available queries will be displayed in the Query list area (1).
    Image RemovedImage Added

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).
    Image Added
  2. Enter a name for the query in the dialog box that opens (2).
  3. Click OK (3).Image Removed

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).
    Image Added
  2. Click the “…” button .

    Info
    titleNote
    Or

    (2) or double-click the query name

    instead of clicking the “…” button

    (1).

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

Image Removed

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).
    Image Added
  2. Click the “-“ button .
    Image Removed

The query will be deleted from the list.

...

titleNote

...

  1. (2) or right-click the query name (1) to open the drop-down menu and

...

  1. 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).
Image Added

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

HideDeny

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 querysubquery

Checkbox

Makes the query a slave

Boolean

-

Yes the query is a slave.

No the query is not a slave

6

Slave querySubquery

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

...

titleNote

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).

...

Image Added

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 Word Substring field (1).
    Image Added
  2. Click the Find Select button (2).
  3. The query names containing the word will be highlighted in the Query list (3).

...

The word search for queries in the Query list is  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).
    Image RemovedImage Added
  2. Save the query file in the standard Windows file save dialog box.
    Image RemovedImage Added
  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.
Info
titleNote
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.