Return a new filter with the specified filter string
Namespace: Com.Tibco.As.Space.FilterAssembly: TIBCO.ActiveSpaces.Common (in TIBCO.ActiveSpaces.Common.dll) Version: 2.0.0.0 (2.1.5.12)
Syntaxpublic static Filter Create(
string filter
)
Public Shared Function Create (
filter As String
) As Filter
public:
static Filter^ Create(
String^ filter
)
static member Create :
filter : string -> Filter
Parameters
- filter
- Type: SystemString
A filter string can be seen as what would follow the where clause in a
"select * from Space where..." statement.
Any field in the tuple may be used and field names are case-sensitive.
Return Value
Type:
FilterThe new Filter instance
Remarks
The following operators are supported in the ActiveSpaces filters.
- >, >= : greater than
- NOT or ! or <> : not
- * : multiply
- = : equal
- != : not equal
- ABS : absolute value
- MOD : modulo
- NOTBETWEEN : not between
- BETWEEN : between
- || : string concatenation
- NOTLIKE: not like (regex)
- LIKE: like (regex)
- <, <= : less than
- + : addition
- OR: or
- - : subtraction
- AND: and
- IN : range, as in "age in (1,3,5,7,11)"
- NULL : does not exist
- NOT NULL : exists
- IS : only used with NULL or NOT NULL
- NOR: nor as is "age NOT 30 NOR 40"
- /* ... */ : multiple line comments
- // .... : single line comments
The format for the values are:
- \oXXX : octal value
- \xXXX : Hexadecimal value
- XXXEYY: exponents (as in 1E10 or 1E-10)
- YYYY-MM-DDTHH:MM:SS:uuuu+/-XXXXGMT: datetime
- YYYY-MM-DD : date
- HH:MM:SS:uuuu+/-XXXXGMT: time
- TRUE : true
- FALSE : false
See Also