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"])

About this Article
  • Created: 05/23/2017 8:38 am EDT
  • Last updated: 11/30/2017 7:02 am EST
In This Article