Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Wildcards Datatypes Literals Identifiers and Keywords

Event Stream Processing supports various wildcards, datatypes and keyword which can help in creating the queries.

## Wildcard Characters

- The asterisk (*) is a wildcard character, meaning "all"
- The single quote (’) is a single character wildcard

## Datatypes

All types supported by TIBCO BusinessEvents.

## Literals

Literal values can be of any of the following data types as well as those mentioned in the following table:

- `hex`
- `octal`
- `char`

Note: Octal Values

To specify an octal number, begin the number with a zero (0), for example, 01223 is treated as an octal number.

Do not start decimal numbers with a leading zero. To specify a decimal zero use zero and a decimal point (0.). Do not use 0.0.

## Types and Literals

Query Language Types and Literals
Type | Syntax of Literals | Example
--- | --- | ---
int | A signed integer expressed using only digits and an optional sign prefix. It has a minimum value of -2,147,483,648 and a maximum value of 2,147,483,647 (inclusive). | 1234567
long | A signed integer expressed using only digits and an optional sign prefix. It has a minimum value of -9,223,372,036,854,775,808 and a maximum value of 9,223,372,036,854,775,807 (inclusive). | digits 1234567
double | A double-precision 64-bit IEEE 754 floating point. | 12345.67 1.234e+56
String | String literals are surrounded by double quotes. To escape double quote and backslash characters, prefix them with a backslash. |
    "hello"
    "She says: \"Hello.\""
    "c:\\temp\\myfile"
boolean | The boolean data type has only two possible values: true and false. Use for simple flags that track true and false conditions. |
    true
    false
DateTime |
    yyyy-MM-dd'T'HH:mm:ss.SSSZ
where `yyyy`: four digit year `MM`: two digit month `dd`: two digit day of month `HH`: two digit hour of day in 24-hour format `mm`: two digit minutes in hour `ss`: two digit seconds in minute `SSS`: three digit milliseconds in second `’T’`: the letter T `Z`: timezone expressed as defined in RFC 822. |
    2008-04-23T13:30:25.123-0700
Entity type | `"``entity-project-path``"` Entity project path begins with a forward slash and folders are separated with a forward slash. |
    "/a/b/MyConcept"
Entity | No literal is used for entity instances. | (Not applicable)

## Identifiers

The first character of an identifier must be alphabetical (upper or lower case) or the underscore character. Other characters can be alphabetical or numeric or the underscore character.

## Keywords and Other Reserved Words

The complete list of keywords and reserved words used by TIBCO BusinessEvents and its add-on products is provided in the section Keywords and Other Reserved Words in TIBCO BusinessEvents Developer Guide.

In TIBCO BusinessEvents Event Stream Processing, the restriction is not case sensitive. For example, `last`, `Last` and `LAST` are all reserved.

## Escaping the Keywords

If you want to use keywords as identifiers, resource names, or folder names in your query string, prefix them with the # escape character.

Examples:

    select id from /PO/#Order o
    select /#DateTime/format(birthDate, "yyyy-MM-dd") from /Person
    select e.sender as #from from /Email e

Where the following are the types items that use keywords:

`#Order` is a concept name

`#DateTime` is a function catalog category whose name happens to be a keyword (only category names that are keywords need to be escaped)

`#from` is an alias

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.