Support for Queries
The SQL Workflow Instance Store records a set of well-known properties in the store. Users can query for instances based on these properties. The following list contains some of these well-known properties:
Site Name. Name of the Web site that contains the service.
Relative Application Path. Path of the application relative to the Web site.
Relative Service Path. Path of the service relative to the application.
Service Name. Name of the service.
Service Namespace. Name of the namespace that the service uses.
Last Machine. The computer on which the workflow service instance ran the last time.
For self-hosted scenarios using Workflow Service Host, only the last four properties are populated. For Workflow Application scenarios, only the last property is populated.
The workflow runtime supplies values for the first three properties. The workflow service host supplies the value for the Suspend Reason property. The SQL Workflow Instance Store itself supplies values for the Last Updated Machine property.
The SQL Workflow Instance Store feature also lets you specify the custom properties for which you want to store the values in the persistence database and that you want to use in queries. For more information about custom promotions, see Store Extensibility.
The instance store contains the following views. See Persistence Database Schema for further details.
The Instances view contains the following fields:
The ServiceDeployments view contains the following fields:
The InstancePromotedProperties view contains the following fields. For details on promoted properties, see the Store Extensibility topic.
Value# (a range of fields from Value1 to Value64).