Sub-queries and sub-components
Sub-queries and sub-components are the solution for extended requirements.
- A selection of a query can start a certain further selection: Only if salad is selected, dressings are queried.
- A selection can book certain components: Only if salad is selected will disposable cutlery be included.
- Certain queries and components only apply to the POS system or assortments: different behavior of the same item depending on the booking system.
Subqueries are not compatible with the optional Yes No queries.
Use of 3rd parties: Please note the performance of your 3rd party system, whether they support sub-queries or have a look at our compatibility table for function comparison.
Best practice generally valid for eSolutions, 3rd parties and webshops
It is crucial for your success at your location to also serve eSolution Channels. In order to secure your processes for customer satisfaction and last but not least for the legal security of your location, there must be a central system that contains your complete offer and prioritizes and coordinates orders from production to invoicing. The aim here is not only to have a common database, but also to present the optimum offers, customisations and upsells for all areas.
You can achieve this squaring of the circle by adding subqueries to the individual items and configuring them differently with the assortments P, A, B and C per channel.
Use assortments...
Assortments can be used for areas such as delivery services, self-order terminals and 3rd party integrations and allow you to distribute different offers from a common article master. Items can be assigned to one or more assortments, and certain programmes can apply this assignment. Its use is similar to a filter and allows you to customise items in certain areas.
In addition to the option of only offering articles in certain product ranges, it can also be useful to create the same article several times in order to book it differently at the checkout than at the self-service terminal. With assigned assortments, you can then select the appropriate range of articles depending on the application. Assortments can therefore also control different queries within an article, so that the article appears differently at the checkout than at the self-order terminal.
Specify which product range you want to use (A B C D E F G H). Please note that you should create a concept for your article data if you also want to use it in other areas or with other connections. Read more at Best practice for article master data for eSolutions.
Special feature Assortments for POS queries...
You can use assortments in queries so that an item behaves differently depending on the channel's assortment: Assortments in connection with queries
Subqueries
Queries can enable further selection options through sub-queries. In this way, the degree of hotness of the chilli peppers or the colour of the olives can be additionally selected (as in the example here).
Sub-queries are always connected to the previous query and cannot be used separately. The selection in the example would be as follows: Pasta Vegetaria: Olives (black olives), Pepperoni (hot peppers).
Sub-queries are always treated as forced queries, so a selection must be made if a sub-query is present. Multiple selection is also possible in connection with sub-queries. The + and - can be used to adjust the desired number of a sub-query. In the example, we can select 2 x mild peppers as an extra. Sub-queries can have an additional differential price, which changes the price of the query and thus the price of the item. In the example, the olives cost 1.00 euro, since the sub-queries are also compulsory queries, the difference price of the sub-query "black olives" of 0.11 euro is compulsorily added here
If you need information on the SOT, please see Sub-queries at the SOT.
For queries and components, there is a small + next to the name, which opens a query / component and allows you to subordinate queries / components to this entry.
The assigned subcomponents/queries are highlighted in color:
These have only one query hook to decide whether it is a query or a component. The superordinate values for number / constraint (column headings) are not used for the sub-components (as well as clearly colored).
The controls for price levels, validity, inhouse/outhouse and split are not applied to subqueries and components and are therefore blocked.
Assortments in connection with queries
The Assortment P selection is a static supplement that is only used in this area to separate the standard assortments from an additional option at the POS:
Here you can see the functionality, the choice of validity of an assortment or at POS. Assortment P is synonymous with "Assortment POS". Only the activation of P releases the respective query or components for the Hypersoft POS, mPOS and Clou Mobile for Windows and Orderman If an assortment is deactivated, it is not displayed and not posted by the corresponding system. The ranges A-D are intended for extended control for web shops and other connected systems such as 3rd parties.
The assortment hooks can be activated with the right mouse button for all others starting from the selected line (as with the queries). Example: right mouse button at the penultimate line activates this and the last line.
Note: Assortment "P" is not available as a switch. Each item has set this automatically internally (or there is none at all). The "P" serves only as a designation of the switch in the queries and components.
There is no change here with regard to product ranges. As before, POS books everything that is saleable in the item master.
The only new feature is the filter "P", which signals that this query is present at the POS. If the check mark is off, the query / component is NOT present. Equivalently, it is now possible to control the assortments for webshops. Queries / components for POS and web shops are entered and the application is now controlled via these switches.
Sub-queries at POS
The sub-queries are only performed when a corresponding query is selected.
These are then displayed as "Popup" in each case. In the case of multiple queries (here 3), the popup appears again for EVERY query.
Subqueries at the mPOS
There are no major differences here, subqueries may simply appear in another window.
Printout of the subqueries on order receipts and forms
Back to the parent page: Basic Knowledge 4: Components and Queries