I try to receive from my postgres function multiple-row answer, but I received only one row (first row) at workflow.
Is it possible to receive few rows in workflow cmdbuild?
pgadmin returns me 3 rows: SELECT usersbyrole('A','SuperUser');
in workflow - only first row:
spResultSet = cmdb.callFunction("usersbyrole").with("status", "A").with("role", "SuperUser").execute();
result = spResultSet.get("result");
===============my function==================
CREATE OR REPLACE FUNCTION usersbyrole(IN status character varying, IN role character varying, OUT result character varying)
RETURNS SETOF character varying AS
$BODY$
SELECT "Description" FROM "User" WHERE ("Id" IN (SELECT "IdObj1" FROM "Map_UserRole" WHERE "Status" = $1 AND "IdObj2" IN (SELECT "Id" FROM "Role" WHERE "Description" = $2 )));
$BODY$
LANGUAGE sql VOLATILE;
COMMENT ON FUNCTION usersbyrole(character varying, character varying) IS 'TYPE: function';