Record.SelectFields

Syntax

Record.SelectFields(record as record, fields as any, optional missingField as nullable number) as record 

About

Returns a record which includes only the fields specified in list fields from the input record.

Example 1

Select the fields "Item" and "Price" in the record.

Record.SelectFields( [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0] , {"Item", "Price"})
Item Fishing rod
Price 100