Open topic with navigation

TIBCO Business Studio™ - BPM Edition 5.4.0

# Values

Values in DQL expressions use constants.

## Constants

Type | Notes | Examples
--- | --- | ---
String | Must be single-quoted only. Single quote characters in single-quoted strings must be escaped using a backslash character ('\'). A backslash character must be escaped using a second backslash character. |
    'bill'
    '\'fred'
    '\\fred'
Numeric |  |
    0
    -123
    123.456
Date | Must be specified as: YYYY-MM-DD A timezone can be specified by appending the date with either "Z", "+HH:MM" or "-HH:MM". When doing date range checking you can abbreviate dates, leaving off the non-significant parts. |
    2013-12-25
    2013-12-25Z
    2013-12+08:00
    2013-05:00
The following expression searches for a date of 2013 or later.
    dispatchNote.dateOfDispatch > 2012
Time | Must be specified as: HH:MM:SS.SSS When doing time range checking you can abbreviate times, leaving off the non-significant parts. |
    14:23:56.123
The following expression searches for a time of 09:00:00 or later.
    openingTime >= 09:00
Datetimetz | Must be specified as: YYYY-MM-DDTHH:MM:SS.SSS A timezone must be specified by appending the date with either "Z", "+HH:MM" or "-HH:MM". When doing range checking you can leave off the non-significant parts. |
    2013-12-25T00:00:01Z
    2013-12
    2013-12-25T09+05:00
    2013-12-25T00:00:01-08:00
Enum | Enum names must be quoted with either single or double quotes. |
    orderLines.orderItem.itemEvents.event = 'RECEIVED'
    orderLines.orderItem.itemEvents.event IN ("RECEIVED", "SHIPPED")

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.