The Database Writer is capable of running very specific actions for a given list action (new/edit/delete) based on a user-defined action filter that can be used against the currently executing list item.
Example:
<ComplexFilters>
<ComplexFilter runOn="edit">
<Filter>[Status]=’Completed’</Filter>
<ActionURL>http://lob.corasworks.net/filters/actions</ActionURL>
<Items>
<Item internal="false">
<Name>Title</Name>
<Field>Title</Field>
</Item>
</Items>
</ComplexFilter>
</ComplexFilters>
Elements and Attributes (all except “internal” are required):
• runOn (attribute of each <ComplexFilter>): Tells the control which List Item event to run the complex process on. This value can be new, edit, or delete.
• Filter: The filter to run against the data to determine if the ActionURL should be called.
• ActionURL: The URL to be called if the filter has matched the current list item data.
• Items: Parent element for SharePoint list field values to capture and send along to the ActionURL.
• Item: Child element containing a <Name>,<Field> pair for each column of data you want to pass to the ActionURL.
• Internal (optional attribute of each <Item>, default is false): Set to true to use the internal field name of the of the column you want to reference; otherwise the column’s display name is assumed. Possible values are true or false.
• Name: The name to use for the parameter that will be sent forward to the ActionURL.
• Field: The name of the SharePoint field to pull data from; its value will be used for the parameter value that will be sent forward to the ActionURL.