iNTERFACEWARE™ Inc.

To Message Filter

In order to configure the To Message Filter destination component described in the Channel Destination Components section of the manual, you must define the following properties:

The Database API, Data Source, Database Username and Database Password define where the inbound data and the error message logs will be stored. The data source specified by these fields defines the location of the status table that processes the outbound message filters. This status table is given a name consisting of the name of the channel and the suffix _status. For example, if the channel is named test, the status table is named test_status.

In this status table, one column is defined for each outbound message filter. The column for the first message filter is named s1, the column for the second filter is named s2, and so on. One row of the table is defined for each message sent through this channel; the columns indicate the status of the message for that particular message filter. For example, here is a status table for a channel in which four outbound message filters have been defined:

Control (Status) Table For MySQL

Here are the messages that can appear in a status table:

When a new message is sent through the channel, a new row of the status table is created, and each column in this row is set to W. This tells Iguana that the new message is ready to be processed. When the message is processed, the result for each message filter is updated in the column for that filter.

Changing the Number of Filters

If you change the number of outgoing filters for a channel whose destination is To Message Filter, you must update the status table for the channel to include the new filters. There are two ways to do this:

• Re-export the Destination Data Tables: This will drop the existing status table and replace it with a new one. Any information in the previous status table is lost. If you use this method, be sure to back up your table so that you can restore it if needed. (See Exporting Tables for more details on re-exporting the destination data tables.)

• Manually add the necessary columns to the status table: The status table defines a column for each outgoing message filter. To add a new outgoing message filter, just add a new column to the status table.

If you are adding a column manually, its name consists of the letter s plus the number of the message filter. For example, if you have columns named s1, s2 and s3 and you want to add two more outgoing filters to the channel, the new columns must be named s4 and s5. The properties of these columns must be identical to those of the existing columns in the table.

	If you change the number of outgoing filters for a channel, you do not need to re-export the logs tables. If you re-export the logs tables, Iguana will drop and re-create the logs tables, which could lead to data loss. If you make other changes to a channel whose destination is To Message Filter, you do not need to re-export its database tables.