%Library.Collation

class %Library.Collation

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.

Index transformations are specified via a property's COLLATION parameter. Every datatype has a default COLLATION value, which matches one of the methods of the %Collation class. The COLLATION parameter can be overwritten by an individual property or by a specific index definition.

Note that changing a property's COLLATION value will corrupt any index values currently stored for that property and will require you to manually repopulate the index.

Method Inventory

• AlphaUp()
• Exact()
• FMDEQDate()
• FMDEQTS()
• FMDGEDate()
• FMDGETS()
• FMDGTDate()
• FMDGTTS()
• FMDLEDate()
• FMDLETS()
• FMDLTDate()
• FMDLTTS()
• FMDNEDate()
• FMDNETS()
• FMTSEQDate()
• FMTSEQTS()
• FMTSGEDate()
• FMTSGETS()
• FMTSGTDate()
• FMTSGTTS()
• FMTSLEDate()
• FMTSLETS()
• FMTSLTDate()
• FMTSLTTS()
• FMTSNEDate()
• FMTSNETS()
• MVDEQDate()
• MVDGEDate()
• MVDGTDate()
• MVDLEDate()
• MVDLTDate()
• MVDNEDate()
• Minus()
• Mvr()
• Plus()
• Space()
• SqlString()
• SqlUpper()
• String()
• TSEQDate()
• TSEQMVDate()
• TSGEDate()
• TSGEMVDate()
• TSGTDate()
• TSGTMVDate()
• TSLEDate()
• TSLEMVDate()
• TSLTDate()
• TSLTMVDate()
• TSNEDate()
• TSNEMVDate()
• Truncate()
• Upper()

Methods

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.

classmethod Exact(%val As %String) as %String

Performs no transformation; the index value is exactly the logical value.

classmethod FMDEQDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the = operator.

classmethod FMDEQTS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

These methods deal with comparing %Library.FilemanDate values with %Library.TimeStamp Compares a %FilemanDate to a %TimeStamp value with the = operator.

classmethod FMDGEDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the '< operator.

classmethod FMDGETS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

Compares a %FilemanDate to a %TimeStamp value with the '< operator.

classmethod FMDGTDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the > operator.

classmethod FMDGTTS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

Compares a %FilemanDate to a %TimeStamp value with the > operator.

classmethod FMDLEDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the '> operator.

classmethod FMDLETS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

Compares a %FilemanDate to a %TimeStamp value with the '> operator.

classmethod FMDLTDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the < operator.

classmethod FMDLTTS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

Compares a %FilemanDate to a %TimeStamp value with the < operator.

classmethod FMDNEDate(fmd As %FilemanDate, d As %Date) as %Boolean

Compares a %FilemanDate to a %Date value with the '= operator.

classmethod FMDNETS(fmd As %FilemanDate, ts As %TimeStamp) as %Boolean

Compares a %FilemanDate to a %TimeStamp value with the '= operator.

classmethod FMTSEQDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the = operator.

classmethod FMTSEQTS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the = operator.

classmethod FMTSGEDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the '< operator.

classmethod FMTSGETS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the >= operator.

classmethod FMTSGTDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the > operator.

classmethod FMTSGTTS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the > operator.

classmethod FMTSLEDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the '> operator.

classmethod FMTSLETS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the <= operator.

classmethod FMTSLTDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the < operator.

classmethod FMTSLTTS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the < operator.

classmethod FMTSNEDate(ts As %FilemanTimeStamp, d As %Date) as %Boolean

Compares a %FilemanTimeStamp to a %Date value with the '= operator.

classmethod FMTSNETS(fmts As %Library.FilemanTimeStamp, ts As %Library.TimeStamp) as %Boolean

Compares a %FilemanTimeStamp to a %TimeStamp value with the '= operator.

classmethod MVDEQDate(mvd As %MV.Date, d As %Date) as %Boolean

---------------------- These methods deal with comparing %MV.Date values with %Library.Date The MultiValue start date is 01/01/1968
Cache' start date is 01/01/1841

To convert a Cache' date ($h) to a MultiValue date:
MVdate = CACHEdate - 46385

To convert a MultiValue date to a Cache' date:
CACHEdate = MVdate + 46385
---------------------- Compares a %MV.Date to a %Date value with the = operator.

classmethod MVDGEDate(mvd As %MV.Date, d As %Date) as %Boolean

Compares a %MV.Date to a %Date value with the '< operator.

classmethod MVDGTDate(mvd As %MV.Date, d As %Date) as %Boolean

Compares a %MV.Date to a %Date value with the > operator.

classmethod MVDLEDate(mvd As %MV.Date, d As %Date) as %Boolean

Compares a %MV.Date to a %Date value with the '> operator.

classmethod MVDLTDate(mvd As %MV.Date, d As %Date) as %Boolean

Compares a %MV.Date to a %Date value with the < operator.

classmethod MVDNEDate(mvd As %MV.Date, d As %Date) as %Boolean

Compares a %MV.Date to a %Date value with the '= operator.

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.

classmethod Mvr(%val As %String) as %String

Converts a logical value to MVR collation

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.

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.

classmethod SqlString(%val As %String, maxlen As %Integer = 32768) as %String

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.

classmethod SqlUpper(%val As %String, maxlen As %Integer = 32768) as %String

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.

classmethod String(%val As %String, maxlen As %Integer = 32768) as %String

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.

classmethod TSEQDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the = operator.

classmethod TSEQMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

---------------------- These methods deal with comparing %MV.Date values with %Library.TimeStamp ---------------------- Compares a %TimeStamp to a %MV.Date value with the = operator.

classmethod TSGEDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the '< operator.

classmethod TSGEMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

Compares a %TimeStamp to a %MV.Date value with the '< operator.

classmethod TSGTDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the > operator.

classmethod TSGTMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

Compares a %TimeStamp to a %MV.Date value with the > operator.

classmethod TSLEDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the '> operator.

classmethod TSLEMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

Compares a %TimeStamp to a %MV.Date value with the '> operator.

classmethod TSLTDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the < operator.

classmethod TSLTMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

Compares a %TimeStamp to a %MV.Date value with the < operator.

classmethod TSNEDate(ts As %TimeStamp, d As %Date) as %Boolean

Compares a %TimeStamp to a %Date value with the '= operator.

classmethod TSNEMVDate(ts As %TimeStamp, d As %MV.Date) as %Boolean

Compares a %TimeStamp to a %MV.Date value with the '= operator.

classmethod Truncate(%val As %String, len As %Integer) as %String

Converts a logical value to exact colation with a defined length limit

classmethod Upper(%val As %String) as %String

Converts a logical value to upper case without removing any characters.