Genpact Cora Knowledge Center


Execute a Stored Procedure or Service from an Expression


Follow these steps to execute a stored procedure or a service from an expression.


  • Create a WCF service that returns a list of objects. The service can be a stored procedure or any other service, but it must return lists of objects.
  • Define the WCF service as a query in a form's data model. The query parameters can be basic.


  • Write an expression that executes a stored procedure or service. See below for examples.

Example Expressions that Execute a Stored Procedure or Service

General example:


Defined parameters example:

{Form}.Query("CheckCondition", new Object[] { act.ActivityInstanceId }).First()["Result"])

Inside of a condition example:

ToBoolean({Form}.Query("CheckCondition", new Object[] { act.ActivityInstanceId }).First()["Result"])