Building a Query

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

query_builder_window_blank.png

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:

query_builder_123.png

 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.

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.

query_builder_right_side.png

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.

query_and_or_arrow.png

 

 

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

query_building_save_query.png

 

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

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

query_count_matching_items.png

 

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 4.14.05.05

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk