Queries tab

  1. Access the Queries tab of the planning engine definition.
  2. Click New (+).
  3. Specify this information:
    Name
    A unique name of the planning engine definition query.
    Display Name
    The name to be displayed for 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.
  4. Click Add Condition to add a new condition to the query definition.
  5. 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.
  6. 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.
A query is limited to Buckets and one class definition. If the fields from multiple classes are defined this error is logged during the validation process:
Multiple class references are not allowed.