Open topic with navigation

TIBCO Business Studio™ - BPM Edition 5.4.0

# 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`

Subtopics

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO Business Studio™ - BPM Edition

Copyright © 2015-2023. Cloud Software Group, Inc. All Rights Reserved.