Adding new query
- Access the Queries tab of the planning engine definition.
- Click New (+).
- Specify this information:
- Name
- A unique name of the planning engine definition query.
- Category
- The category in which the query is grouped. You can create a new category or select from the categories already defined.
- Click Add Condition to add a new condition to the query definition.
-
Specify this information:
- Condition
- The condition or logic to be applied for the query.
Possible values:
- ADD: Includes data for Field by matching the values specified in Operator and Value and defining the union of the two result sets. This operation is equivalent to performing a OR logic between two result sets.
- LIMIT: Restricts data for Field by the values specified in Operator and Value and defining an intersection between two result sets. This operation restricts the first result set to the resources that also satisfy the second qualifier and is equivalent to performing an AND logic between two result sets.
- RESET: Deletes the first result set and returns the second result set only. This operation is useful for the sets of the bucket type when two property-based qualifiers are evaluated in two different buckets of the planning horizon.
- Field
- The possible values are based on the values specified in
the Condition, Operator and Value fields. The list of all
classes derived fields are defined in these formats:
- Class.name
- Class.attribute
- Class.effectivity at
- Class.effectivity from
- Class.effectivity to
- Class.property
- Class.property(*)
Note:- Where Parent A is the class exists and Child B is the name, attribute and so on, exists for the parent.
- Additional System fields includes:
- Bucket.start
- Bucket.end
- Bucket.name
- Operator
- The operator to be used in creating query condition.
Possible values:
- Does not equal
- Equals
- Greater than
- Greater than or equal to
- Less than
- Less than or equal to
These String operators are only available for Class.name and Bucket.name fields:
- Contains
- Does not contain
Note: Date, String and Numerical value field types are considered for query evaluation. - Value
- The value to which the condition is applied.
-
Click Add. The query is added to
the list.
Note:
- Move a query up within the list using the Move Up option.
- Move a query down within the list using the Move Down option.