IBM BPM, V8.0.1, All platforms > Programming IBM BPM > Business rule management programming > Examples

Additional Query Examples

The following examples are not included with the application containing examples 1-15, however they provide more examples on creating queries to retrieve business rule groups.

In these examples different properties and wildcard values (‘_’, ‘%’) are used with different operators (AND, OR, LIKE, NOT_LIKE, EQUAL and NOT_EQUAL).

Example

For the examples, queries will be performed that return between different combinations of 4 business rule groups. It is important to understand the different attributes and properties of the business rule groups as these are used in the queries.

Name: BRG1
Targetnamespace : http://BRG1/com/ibm/br/rulegroup
Properties:
organization, 8JAA
department, claims
ID, 00000567
region: SouthCentralRegion
manager: Joe Bean

Name: BRG2
Targetnamespace : http://BRG2/com/ibm/br/rulegroup
Properties:
organization, 7GAA
department, accounting
ID, 0000047
ID_cert45, ABC
region: NorthRegion

Name: BRG3
Targetnamespace : http://BRG3/com/ibm/br/rulegroup
Properties:
organization, 7FAB
department, finance
ID, 0000053
ID_app45, DEF
region: NorthCentralRegion

Name: BRG4
Targetnamespace : http://BRG4/com/ibm/br/rulegroup
Properties:
organization, 7HAA
department, shipping
ID, 0000023
ID_app45, GHI
region: SouthRegion

• Query by a single property
  This is an example of a query by a single property.
• Query business rule groups by properties and wildcard (%) at the beginning and at the end of the value
  This is an example of a query of business rule groups by properties and wildcard (%) at the beginning and at the end of the value.
• Query business rule groups by properties and wildcard (‘_’)
  This is an example of a query of business rule groups by properties and wildcard (%).
• Query business rule group by properties with multiple wildcards (‘_’ and ‘%’)
  This is an example of a query of business rule group by properties with multiple wildcards (‘_’ and ‘%’).
• Query business rule groups by NOT_LIKE operator and wildcard (‘_’)
  This is an example of a query of business rule group by NOT_LIKE operator and wildcard (‘_’).
• Query business rule groups by NOT_EQUAL operator
  This is an example of a query of business rule group by the NOT_EQUAL operator.
• Query business rule groups by PropertyIsDefined
  This is an example of a query of business rule groups by PropertyIsDefined.
• Query business rule groups by NOT PropertyIsDefined
  This is an example of a query of business rule groups by NOT PropertyIsDefined.
• Query business rule groups by multiple properties with a single NOT node
  This is an example of a query of business rule groups by multiple properties with a single NOT node.
• Query business rule groups by multiple properties with multiple NOT nodes combined with AND operator
  This is an example of a query business rule groups by multiple properties with multiple NOT nodes combined with AND operator.
• Query business rule groups by multiple properties with multiple NOT nodes combined with OR operator
  This is an example of a query business rule groups by multiple properties with multiple NOT nodes combined with OR operator.
• Query business rule groups by multiple properties combined with multiple AND operators
  This is an example of a query business rule groups by multiple properties combined with multiple AND operators.
• Query business rule groups by multiple properties combined with AND and OR operators
  This is an example of a query business rule groups by multiple properties combined with AND and OR operators.
• Query business rule groups by multiple properties combined with AND and NOT operators
  This is an example of a query business rule groups multiple properties combined with AND and NOT operators.
• Query business rule groups by multiple properties combined with NOT and OR operators
  This is an example of a query business rule groups by multiple properties combined with NOT and OR operators.
• Query business rule groups by multiple properties combined with nested AND operators
  This is an example of a query business rule groups by multiple properties combined with nested AND operators.
• Query business rule groups by multiple properties combined with nested AND operators
  This is an example of a query business rule groups by multiple properties combined with nested AND operators.
• Query business rule groups by multiple properties combined with nested AND operators and a NOT node
  This is an example of a query business rule groups by multiple properties combined with nested AND operators and a NOT node.
• Query business rule groups by multiple properties combined with nested AND operators
  This is an example of a query business rule groups by multiple properties combined with nested AND operators.
• Query business rule groups by multiple properties combined with nested OR operators
  This is an example of a query business rule groups by multiple properties combined with nested OR operators.
• Query business rule groups by multiple properties combined with nested OR operators
  This is an example of a query business rule groups by multiple properties combined with nested OR operators.
• Query business rule groups by multiple properties combined with nested OR operators and a NOT node
  This is an example of a query business rule groups by multiple properties combined with nested OR operators and a NOT node.
• Query business rule groups by multiple properties combined with nested OR operators and a NOT node
  This is an example of a query business rule groups by multiple properties combined with nested OR operators and a NOT node.
• Query business rule groups by a list of nodes that are combined with an AND operator
  This is an example of a query business rule groups by a list of nodes that are combined with an AND operator.
• Query business rule groups by a list of nodes and NOT node combined with an AND operator
  This is an example of a query business rule groups by a list of nodes and NOT node combined with an AND operator.
• Query business rule groups by a list of nodes that are combined with an OR operator
  This is an example of a query business rule groups by a list of nodes that are combined with an OR operator.
• Query business rule groups by a list of nodes and Not node combined with an OR operator
  This is an example of a query business rule groups by a list of nodes and Not node combined with an OR operator.

Examples