Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Where Clause

The optional `where` clause is analogous to a rule’s conditions. The expression in the `where` clause can be simple or complex.

In the `where` clause you can use following:

- Literal values
- Catalog functions and rule functions
- Entities that are declared in the `from` clause

## Examples

Following checks for NULL values using equality `[=]` operator:

    Select * from /concepts/test as cp where cp.value = null;

Pound or hash (#) is the escape character. See Keywords and Other Reserved Words.

    where A.customerId = B.customerId
    where A.id = B@extid                    // Entity attributes
    and ( B@parent.name = 'ABCD' or C.name = "EFGH" )
    and  A.tokens[5]  = 50                  // array property
    and  ( A.containedConceptE.price > 100
    or B.startTime > /#DateTime/addMinute(/#DateTime/now(),5) )
    and B.value between 2 and 5

Tip: The pound sign (#) is used to escape reserved (key) words. See Keywords and Other Reserved Words for a complete listing.

Did you find this helpful?

YesNo
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 BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.