Search Events Ex

This Calendar tool finds all events in a calendar that fall within a specified date range and that match an input search expression.

Inputs

Calendar ID

This is a Calendar ID from the Open Calendar tool.

Start Date

The start of the event.

End Date

The end of the event. This time must be later than the defined Start Time.

Search Expression

The search expression used by this tool should use the following format:

search_expr  ::= search_expr2

     | search_expr2 OR search_expr

search_expr2  ::= search_expr3

     | search_expr3 AND search_expr2

search_expr3  ::= search_term

     | NOT search_term

search_term  ::= value_expr relop value_expr

     | value_expr LIKE string_constant

     | value_expr NOT LIKE string_constant

     | value_expr IS NULL

     | value_expr IS NOT NULL

     | "(" search_expr ")"

relop   ::= "=" | ">" | "<" | ">=" | "<=" | "<>"

value_expr  ::= property_name

     | constant

constant  ::= string_constant

     | int_constant

property_name  ::= ALPHA (ALPHA | DIGIT | "-")*

string_constant ::= "'" (<any character except "'"> | "''")* "'"

int_constant  ::= <C-style decimal or hexidecimal constant>

In a LIKE expression, use a "_" as a wildcard to match a single character and a '%' to match matches any number of characters.

Outputs

Event IDs

The list of IDs corresponding to the events retrieved by the search.

Exit Paths

Success

This path is taken if the Event ID list is successfully retrieved.

Failure

This path is taken if the operation fails.