A newer version of this content is available on ReWorkflow ReSource.
Technolutions official documentation has a helpful page on User Defined SQL Functions. However, as the page stresses, it's only a partial list. This article will attempt to document additional functions.
Like dbo.getFieldTable(), except that it returns multiple rows.
Returns the Extended prompt value from a field on multiple rows.