ITrkItemAgent.Where (property)

Property Where
Syntax: String = object.Where
object.Where = String
Description:
The Where property indicates the search string to use to find items.

Legend

Symbol Meaning
::= Start of definition
<> Repeat zero or more times
() Group
| Pick one from a list
"" Literal
xyz Rule name
** Optional (once only)

condition
::= logical_term < ( "or" | "||" ) logical_term >

logical_term
::= logical_factor < ( "and" | "&&" ) logical_factor >

logical_factor
::= * "not" | "!" *
( simple_exp comparison_op simple_exp )
| ( "(" condition ")" )
| ( "exists" variable )


simple_exp
::= * "+" | "-" * term < ( "+" | "-" ) term >

term
::= factor < ( "*" | "/" ) factor >

factor
::= constant | variable

comparison_op
::= ">" | ">=" | "<" | "<=" | "=" | "==" | "<>" | "!="

constant
::= ( '"' < character | ( "\" character ) > '"' )
| number


variable
::= ( "`" < character | ( "\" character ) > "`" ) Grave accent character ( ` )

number
::= integer * "." * integer * * * ( "E" | "e" ) * "+" | "-" * integer *

integer
::= digit < digit >

alpha
::= "A" | | "Z" | "a" | | "z"

digit
::= "0" | | "9"

Comparison operations use string compare functions by default, as in Example 1.
To force numeric or floating point comparison, prefix the constant with '#' (numeric) or '%' (floating point)
as in Example 2.

Example 1:
Dim oTrkItemAgent As Object
Dim oTrkItems As Object

Set oTrkItemAgent = CreateObject("Tracker.TrkItemAgent")
oTrkItemAgent.Where ="'COLOR'=='RED'"
oTrkItemAgent.Execute oTrkItems
...
...

Example 2:
Dim oTrkItemAgent As Object
Dim oTrkItems As Object

Set oTrkItemAgent = CreateObject("Tracker.TrkItemAgent")
oTrkItemAgent.Where ="'SPEED'>'#25'"
oTrkItemAgent.Execute oTrkItems
...
...