This functionality is only available for certain module packages.

You are here: Reference > Formula Language > Formulas > Data source objects > perform(String sqlStatement)

perform(String sqlStatement)

Returns a list of all resulting objects of the SQL query to the data source. Each object represents a row of the result. These objects can be accessed by methods that match the requested column names of the data source object. For calculated column names the method property(<column name>) is available.

Example:

The result of perform('select ArticleNumber, Vendor from [Article$] where Vendor=\'Mind8\';') can be accessed by the methods ArticleNumber and Vendor.

perform(String sqlStatement)
Argument String sqlStatement SQL query to the data source
Return value List