This class defines the set of common index transformation (or collation) methods.
An index transformation is used to tranform logical data values into
values used by indices.
For example, you may wish that a query by name finds
the same results for both "ELVIS" and "elvis". Using a case-insensitive
index transformation, such as String, will accomplish this. If you want an exact
match, use Exact.
Copy link to this section Methods
Copy link to this section
classmethod AlphaUp(%val As %String ) as %String
Converts a logical value to upper case, strips all punctuation and white space
(except for ',' and '?').
This method is included for compatability with earlier products; use
String instead.
Converts a logical value to %COLLATE collation
Copy link to this section
classmethod Exact(%val As %String ) as %String
Performs no transformation; the index value is exactly the logical value.
Compares a %FilemanDate to a %Date value with the = operator.
These methods deal with comparing %Library.FilemanDate values with %Library.PosixTime
Compares a %FilemanDate to a %PosixTime value with the = operator.
These methods deal with comparing %Library.FilemanDate values with %Library.TimeStamp
Compares a %FilemanDate to a %TimeStamp value with the = operator.
Compares a %FilemanDate to a %Date value with the '< operator.
Compares a %FilemanDate to a %PosixTime value with the '< operator.
Compares a %FilemanDate to a %TimeStamp value with the '< operator.
Compares a %FilemanDate to a %Date value with the > operator.
Compares a %FilemanDate to a %PosixTime value with the > operator.
Compares a %FilemanDate to a %TimeStamp value with the > operator.
Compares a %FilemanDate to a %Date value with the '> operator.
Compares a %FilemanDate to a %PosixTime value with the '> operator.
Compares a %FilemanDate to a %TimeStamp value with the '> operator.
Compares a %FilemanDate to a %Date value with the < operator.
Compares a %FilemanDate to a %PosixTime value with the < operator.
Compares a %FilemanDate to a %TimeStamp value with the < operator.
Compares a %FilemanDate to a %Date value with the '= operator.
Compares a %FilemanDate to a %PosixTime value with the '= operator.
Compares a %FilemanDate to a %TimeStamp value with the '= operator.
Compares a %FilemanTimeStamp to a %Date value with the = operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the = operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the = operator.
Compares a %FilemanTimeStamp to a %Date value with the '< operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the >= operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the >= operator.
Compares a %FilemanTimeStamp to a %Date value with the > operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the > operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the > operator.
Compares a %FilemanTimeStamp to a %Date value with the '> operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the <= operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the <= operator.
Compares a %FilemanTimeStamp to a %Date value with the < operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the < operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the < operator.
Compares a %FilemanTimeStamp to a %Date value with the '= operator.
Compares a %FilemanTimeStamp to a %PosixTime value with the '= operator.
Compares a %FilemanTimeStamp to a %TimeStamp value with the '= operator.
----------------------
These methods deal with comparing %MV.Date values with %Library.Date
The MultiValue start date is 01/01/1968
ObjectScript date is 01/01/1841
To convert an ObjectScript date ($h) to a MultiValue date:
MVdate = ObjectScript date - 46385
To convert a MultiValue date to an ObjectScript date:
ObjectScript date = MVdate + 46385
----------------------
Compares a %MV.Date to a %Date value with the = operator.
Compares a %MV.Date to a %Date value with the '< operator.
Compares a %MV.Date to a %Date value with the > operator.
Compares a %MV.Date to a %Date value with the '> operator.
Compares a %MV.Date to a %Date value with the < operator.
Compares a %MV.Date to a %Date value with the '= operator.
Copy link to this section
classmethod Minus(%val As %String ) as %String
Prepends a minus ('-') sign to the logical value.
This method is included for compatability with earlier products; you should not
need it in new applications.
Converts a logical value to MVR collation
Compares a %PosixTime to a %Date value with the = operator.
Compares a %PosixTime to a %TimeStamp value with the = operator.
Compares a %PosixTime to a %Date value with the '< operator.
Compares a %PosixTime to a %TimeStamp value with the '< operator.
Compares a %PosixTime to a %Date value with the > operator.
Compares a %PosixTime to a %TimeStamp value with the > operator.
Compares a %PosixTime to a %Date value with the '> operator.
Compares a %PosixTime to a %TimeStamp value with the '> operator.
Compares a %PosixTime to a %Date value with the < operator.
Compares a %PosixTime to a %TimeStamp value with the < operator.
Compares a %PosixTime to a %Date value with the '= operator.
Compares a %PosixTime to a %TimeStamp value with the '= operator.
Copy link to this section
classmethod Plus(%val As %String ) as %String
Prepends a plus ('+') sign to the logical value.
This method is included for compatability with earlier products; you should not
need it in new applications.
Copy link to this section
classmethod Space(%val As %String ) as %String
Prepends a space (' ') character to the logical value.
This method is included for compatability with earlier products; you should not
need it in new applications.
Prepends a space to force string collation and strips trailing whitespace.
This method is used to insure that strings are collated case-sensitively and that numeric
string values are collated correctly.
Converts a logical value to upper case, strips trailing whitespace and prepends a space
to force string collation.
This method is used to insure that strings are collated case-insensitively and that numeric
string values are collated correctly.
Converts a logical value to upper case, strips all punctuation and white space
(except for ',').
This method is used to insure that strings are collated case-insensitively and that numeric
string values are collated correctly.
Compares a %TimeStamp to a %Date value with the = operator.
----------------------
These methods deal with comparing %MV.Date values with %Library.TimeStamp
----------------------
Compares a %TimeStamp to a %MV.Date value with the = operator.
Compares a %TimeStamp to a %Date value with the '< operator.
Compares a %TimeStamp to a %MV.Date value with the '< operator.
Compares a %TimeStamp to a %Date value with the > operator.
Compares a %TimeStamp to a %MV.Date value with the > operator.
Compares a %TimeStamp to a %Date value with the '> operator.
Compares a %TimeStamp to a %MV.Date value with the '> operator.
Compares a %TimeStamp to a %Date value with the < operator.
Compares a %TimeStamp to a %MV.Date value with the < operator.
Compares a %TimeStamp to a %Date value with the '= operator.
Compares a %TimeStamp to a %MV.Date value with the '= operator.
Converts a logical value to exact colation with a defined length limit
Copy link to this section
classmethod Upper(%val As %String ) as %String
Converts a logical value to upper case without removing any characters.