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

 

Adding Queries 

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.

 

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.

query_and_or_arrow.png

 

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