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
!&    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 load_button.png button to populate the field with a list of all available values.



Once you have selected values for your query, the add_button_2.png 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.


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.




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



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



Once you have entered one or a number of query options, the count_matching_records_button.png 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 done_button.png to finish and apply your query to the window you had launched the builder from.


Article written with AmberPOS version

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk