Sample Messaging Format for Multi-Select Columns
Multi-select columns values are in comma-separated format. For values entered as value1, value2, value3, the output would be as follows:
Data row as element
<column name=" ms_column "><![CDATA[value1,value2,value3]]></column>
Table-column as element:
<ms_column><![CDATA[value1,value2,value3]]></ms_column>
Data row as attribute
<datarow transaction_type="INSERT" table="STATE_TBL" ID="2" ms_column="
value1, value2, value3" />
Table-column as attribute
<STATE_TBL transaction_type="INSERT" ID="2" ms_column="value1, value2,
value3" />
Note: | If updates have been made only to multi-select columns, JMS messages are not generated for that object. For delete, restore, and purge operations on data objects, multi -select columns do not appear in the JMS output. |