Skip to content

System functions

VarInfo

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

For example:

Expression
varInfo("boCost","Minimum")

This expression returns £120.

TableInfo

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

Expression
TableInfor("tablename","tableproperty")

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.

For example, TableInfo("bookings","NumRecords") returns the number of records in the Bookings table.

VarCountsInfoNth

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

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

Allowed orderings are:

  • Top
  • Bottom

Allowed return values are:

  • Code
  • Desc
  • Count
  • 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.

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