Use this toolbar to create and work with queries. A query can either give a list of parts matching the query you can then select among the matching parts by clicking on then in the result window. A query can also give a group result you can then manipulate the adjusted forecast or other lines for the total aggregated query result the same way that you will do with a group selection. You can also use the copy down feature with the group function from the query, note that you can only copy the selected parameters down to base flow parts, the parts effected by the copy down is listed in the list view of the query toolbar when you push the group button.
You can create a query in 2 ways Conditions and SQL. The conditions tab lists all available filed names and you fill in the conditions or values of your query. The available operators in the condition tab are:
| Operator | Meaning |
| = | Equals |
| > | Greater |
| < | Less |
| >= | Greater or equal |
| <= | Less or equal |
| <> | Not equal |
| ; or , | List operator, depends on the local settings of the PC. |
You can also get help on setting your conditions by clicking on the drop down button at then end of each field.
If you chose to type in a SQL Query, the syntax is similar to normal SQL see query for details on operators and fields. If you enter a query in the conditions tab and the select the SQL tab you will see how your entered condition looks in SQL.
Toolbars may be turned on/off in the View/Toolbars menu.
N/A
N/A
| Group | Sums all parts that matches the query into one 'group' of parts |
| List | List's all the parts that matches the query, the list is displayed in the result view |
This window contains:
|
Query: |
Write your query in this field, the layout of the query is inspired by SQL. A simple query can be of the form "FLOW_ID = 1 and MAPE > 20", this will give you a list over all parts that has MAPE bigger than 20 in flow 1. Here is a list over fields and operators that are available in the query. |
|
Button: |
This is the button view where you select which type of action you want to perform with the current selected query. Group or List is the options, group gives a sum of all parts matching a query you can then perform actions to this sum as it was a group criteria. List gives you a list over matching parts in the result window, you can then select which of the matching parts you want to take a closer look at. |
|
Result: |
This window lists out all parts that is matching the Query when the list button is pushed. When the group button is pushed the list will show all base flow parts that will be changed, even though the query is written on a combined flow. If you click on a part in the result window that part is selected by the Demand Plan Client. The Part number is listed in the first row the second row is the flow id. |