Case Data Query Language (DQL)

DQL is used to define query expressions that can be used as parameters in the findByCriteria methods to search for case references that match the criteria defined by the query expression.

DQL expressions use the syntax:

attributeName operator value

where:

  • attributeName can be specified as a simple name
  • operator refers to =(equal to). Currently, only this is supported. For details, refer operators
  • value is the value to match against. It can use constants.
Note: Only those attributes which are made searchable at design time can be used to search cases through DQL. Case State and Case Identifier are by default searchable.

For example: 

name = 'Tony Pulis'
Note: This release of BPME currently does not support attributes paths, and values as parameters. Also, it does not support sort, size, between, wildcard characters in DQL. Further, in compound expressions, only AND operator is supported.

Compound Expressions

Simple expressions can be combined with AND to make more complicated expressions. For example, to match records that contain 'London' in the address attribute where the name starts with 'Fred': 

address = 'London' AND name = 'Fred'
Note: AND is case-insensitive.

Reserved Words

The following are reserved words in DQL:
  • and
  • asc
  • between
  • by
  • desc
  • lower
  • not
  • of
  • or
  • order
  • size
  • type
  • upper