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>Title=test</Filter>
<ActionURL>http://lob.corasworks.net/filters/actions</ActionURL>
<Items>
<Item internal="false">
<Field>Title</Field>
</Item>
</Items>
</ComplexFilter>
</ComplexFilters>
Elements:
• runOn: Tells the control when to run the complex process. This value can be new, edit, or delete.
• Filter: The filter to run against the data to determine if the process will run
• ActionURL: The URL url to be executed if the filter has matched the current list item data
• Items: SharePoint list field values to capture and send along to the ActionURL
• Internal: When capturing SharePoint fields, instructs us to use the internal or display name.Possible values are true or false
• Field: The name of the SharePoint field
This string property holds the XML configuration for the Database Writer Field. The configuration will hold values for the insert, edit, and delete URLs, plus which SharePoint list item fields are stored to which database fields.
The parent node of the configuration XML. This sets up the behavior of the database writer field.
A collection of values that will be used to insert or update the data source.
Item (required) – The individual item that will be used in the data source.
• Internal (attribute, optional) – Set to true to use the internal field name of the item.
• Name (required) – The name of the parameter that will be sent forward to the adapter.
• Field (required) – The display name of the list item field whose value will be sent to the adapter.
The URL of the provider that handles the deletion of the record when the list item is deleted. This property also supports the Common Use Variables stated at the beginning of this help topic.
The URL of the provider that handles the editing of this record when the item is updated. This property also supports the Common Use Variables stated at the beginning of this help topic.
The URL of the provider that handles the insertion of this record when a new item is created. This property also supports the use of the variables <%SiteURL%> and <%HostName%>.
The following are a list of additional values sent along with each request to the adapter. These values may be used when configuring your adapter for any insert, update or delete action.
• ListItemIDGuid – The unique GUID value of the list item.
• ListItemID – The list item ID. This value may not be unique across multiple lists.
• ListID – The list id of the list the database writer is a member of.
• ListTitle – The title of the list the database writer is a member of.
• ListURL – The list URL of the list the database writer is a member of.
• SiteTitle – The site title of the site the list is a member of.
• SiteURL – The site URL of the site the list is a member of.
• ListEdit- The edit form URL of the list the database writer is a member of.
• ListNew – The new form URL of the list the database writer is a member of.
• ListDisplay – The display form URL of the list the database writer is a member of.
Example:
<Configuration>
<InsertURL>http://mysite.com/edp/insert</InsertURL>
<EditURL>http://mysite.com/edp/edit</EditURL>
<DeleteURL>http://mysite.com/edp/delete</DeleteURL>
<DatabaseValues>
<Item>
<Name>Item1</Name>
<Field>Title</Field>
</Item>
<Item internal="true">
<Name>Item2</Name>
<Field>Statusx00xField</Field>
</Item>
</DatabaseValues>
</Configuration>
Controls the sequence for which all Database Writers in the list will execute. Specify any number greater than 10000.