Cookbook: SOW Delete

This section presents common recipes for sending a sow_delete command using the Command or Message interfaces. This section provides information on how to configure the request to AMPS. You can adapt this information to your application and the specific interface you are using.

Command: sow_delete

Delete All Records in a SOW

To delete all records in a SOW, provide a filter that evaluates to TRUE for every record in the SOW. By convention, 60East recommends 1=1 for the filter.

Header	Comment
Topic (required)	Sets the topic from which to remove records.
Filter (required)	A filter specifying the messages to remove. By convention, use 1=1 to remove all records in the SOW.

Delete SOW Records Matching a Filter

To delete the records that match a particular filter, provide the filter in the sow_delete command.

Header	Comment
Topic (required)	Sets the topic from which to remove records.
Filter (required)	A filter specifying the messages to remove.

Delete a Specific Message by Data

To delete a specific message, provide the data for the message to delete. With this form of SOW delete, AMPS deletes the message that would have been updated if the data were provided as a publish message. Notice that this form of sow_delete relies on the Key definition in the SOW configuration, and is not generally useful with explicitly-keyed SOW topics.

Header	Comment
Topic (required)	Sets the topic from which to remove records.
Data (required)	The message to remove.

Delete Specific Messages using Keys

To delete specific messages using SOW keys, provide the SOW keys for the message to delete.

Header	Comment
Topic (required)	Sets the topic from which to remove records.
SOWKeys (required)	A comma-delimited list of SOW Keys that specify the messages to remove.

Acknowledge Messages from a Queue

To acknowledge messages from an AMPS queue, provide the bookmarks for the messages to acknowledge. Notice that this is the only form of the sow_delete command that can acknowledge messages from a queue, and that this form of sow_delete is not accepted for topics that are not queue topics.

Header	Comment
Topic (required)	Sets the topic that contains the messages to acknowledge.
Bookmark (required)	A comma-delimited list of Bookmarks that specify the messages to acknowledge.