Cache - SuperOffice

Cache to often used db tables and structures and retrieve them in a useful and structured fashion

Constructors

Cache

Initializes a new instance of the Cache class.

Checks if there are no more fields in the result.

Bool eof()

Returns: CRMScript.Global.Bool - True if it is at end of file or there are no more fields to iterate through; otherwise, false.

A common usage is in the condition section in a for loop.

Sets the iterator variable to the first field in the field set.

Bool first()

Returns: CRMScript.Global.Bool - False if the field set is empty; otherwise, true.

This function will return data from a cached table.

String getData(String tableId)

Returns: CRMScript.Global.String - Data from the cached table specified in tableId.

Returns a subset of the data for a cached table based on a filter, where a field must have a given value.

getDataSubset(String tableId, String filterField, String filterValue)

Returns: CRMScript.Global.String - The rows from the table where filterField = filterValue.

Returns a row of fields.

Map getRow()

Returns: CRMScript.Native.Map - A row of fields.

Sets the iterator to the next field.

Bool next()

Returns: CRMScript.Global.Bool - False if at end of file or the field set is empty; otherwise, true.

Sorts the cached data by given field in given order.

sort(String field, Bool order)

Returns: CRMScript.Global.Void