GetCustomTableRecordwithfilters

This custom table records function is available on intellisense location MCLD.Functions.CustomTables.GetCustomTableRecords.

Method Signature:

GetCustomTableRecords (tableName, async, callback, addparam, camelCase)

Sample Response:

 '{"totalRecords":4,"records":[{"autoId":"1","workflowName":"Create workflow","executionMoid":"xxx"},
{"autoId":"2","workflowName":"Delete Workflow","executionMoid":"xxxxx"},
{"autoId":"3","workflowName":"Test","executionMoid":""},{"autoId":"4","workflowName":"","executionMoid":"1"}]}'

Parameter Details:

Table 1. GetCustomTableRecordWithFilters
Parameter Name Type Mandatory Description
Table Name String Y User must pass the Table Name which are visible under Master> Custom table menu.
Async Boolean N

In case it’s False:

Function will be called in synchronous mode. i.e. Current execution will wait for method execution to complete

In case it’s True:

Function will be called asynchronously. Execution will not wait for method execution completion. It will jump to next statement.
Callback Function N User can pass function name that can be executed on completion of Parent function call.
addlparam Object N

Addlparam is used for filtering and sorting the records. It contains 3 properties filter/sortby/sortorder.

To Filter:

To filter records based on column name received from output. e.g., filter="keyname='keyvalue'"

To Sort by:

To sort the data based on column name. e.g., sortby="keyname"

To Sort Order:

To define sorting order either ASC (Ascending) or DESC (descending). e.g., sortorder="ASC”
camelCase Boolean N Convert custom table column casing. If true custom table column will be converted to camel case else it will be returned as it is. Default value is true.