Expression: System Functions

VarInfo

Use this function to return the value of a property for a given variable. Use the variable reference not name.

varInfo("boCost","Minimum")

Returns, for example, £120

TableInfo

Use this function to return the value of the property for the given table.

Allowed properties are: NumRecords, NumRecordsMatchParent, MinMatches, MaxMatches

The result is a number. If a property is not defined for the given table then a missing value is returned.

TableInfor("tablename","tableproperty")

e.g. TableInfo("bookings","NumRecords") - returns the number of records in the Bookings table

Use this function to return the value of the property for the given variable.

Allowed orderings are Top or Bottom. Allowed return values are Code, Desc, Count or Index.

Omit Unclassified is optional and is false by default. If a property is not defined for the given variable then a missing value is returned.

VarCountsInfoNth("variablename","ordering","Nth number","returnvalue","omitunclassified")

e.g. VarCountsInfoNth("boDest","Top",1,"Desc") - returns the description of the Booking Destination with the highest instant count