Building a Query

There are several options which will require you to build a query using the Query Builder window.

Your window may not look exactly the same as the examples but the functions will be the same.

There are three main components to every query:

 In the example a query for all SKUs with a value of 1010 or greater has been entered and is ready to be added.

1. The unit you wish to use to refine your query. The list may have different values depending on the type of query selected.

2. Modifiers for the unit selected in step 1. Again, these values will vary depending on unit selected.
=     EQUAL To
!=    Not EQUALTo
<     LESS than
>     GREATER than
<=   LESS than OR EQUAL to
>=   GREATER than OR EQUAL to
$     CONTAINS
!&    Does not CONTAIN
B     BEGINS with
!B    Does not BEGIN with

You can also figure out what they are by hovering over them, or changing the dropdown in the "current query" area on the right.

3. Values for the query. Can be typed in manually, or if available press the button to populate the field with a list of all available values.

Adding Queries 

Once you have selected values for your query, the button will add it to the list of chosen options on the right. You can also use this section to edit already added queries.

In the example, the query from the previous step is ready to be added to the list. Already added to the list is a query for all items whose quantity on order is less than 77.

And/Or Operator

With multiple options selected, use the AND/OR dropdown box to select whether you would like to have your items meet all the added options at once, or any single one of them.

Sorting Priority

When you list queries in the query builder, as with mathematics, there can be a sequence of operation as to which values are considered for comparison first to last.  When there are multiple queries, you can specify which combination of AND/OR Operators are managed first to last.  To do so, assign the highest numeric value to the values to be managed first, and the lower numeric values to the values to be managed last.

With the example above, the following order of operation is managed.

((Department=Electronics AND Brand=Apple) OR (Department=Kitchen AND Brand=Samsung))

The result of this query will be products that are in the department Electronics, while having the brand Apple, or products in the department Kitchen, while having the brand Samsung.

Saving Queries

You can save your query for future use by entering a name into the Query Name field and pressing .

Or you can load previously saved options by selecting a saved query from the list and pressing .

Once you have entered one or a number of query options, the button will display the number of items which match your options, without actually displaying the items themselves.

Once you are satisfied with your selections, press to finish and apply your query to the window you had launched the builder from.

Article written with AmberPOS version 4.14.05.05