Condition |
Scroll |
Gets or sets the condition string.
Namespace: Therefore.API
Visual Basic Public Overridable Property Condition As String C# public virtual string Condition { set; get; }
Property Value A string representing the condition. |
Condition strings can contain any value or operator valid for the associated field's type. Values 0-9 are valid for Currency and Number type fields, any alphanumeric text string for Text types, any date (in the local PC's date format) for Date fields or all valid keywords for keyword fields. The format used for decimal numbers (. or ,) and Date (mm/dd/yy, dd/mm/yy etc) are dependent on the local PC's (Windows O/S) default setting.
Functions can be combined to form complex search expressions. For example: ">4711 AND <=5607" searches for index data 'greater than' 4711 and 'smaller than or equal to' 5607. ">=4711 OR 2303" searches for index data 'greater than or equal to' 4711 or (equal to) 2303.
UTC and time zones By default all date and time values are considered to be in UTC, except it is specified otherwise by the IsUTC property or the bIsUTC parameter in TheConditionList.Add method overloads. If IsUTC is false, the time zone specified in TheCultureInfo.TimeZoneInfoID returned by TheServer.GetCultureInfo is used for UTC conversion internally. If no culture info has been set, the time zone of the current user context will be used. |