rowData parameter
The rowData parameter represents the entire row's data (all the cell values, modifications, differences, etc.).
The rowData parameter is read-only and cannot be modified with import, export or display rules. There are two specific rules which does let you modify the rowData:
Export Manipulation
Comparison Rule
The rowData object has some properties that can be considered stable (will never change, be renamed or removed by developers):
cells
The primary source cells as it arrives from the source
modifications
Any changes made to a row on screen of through import rules. The cell will have a green rectangle.
differences
Any values that are different to the primary source values. If Qty has a value of 5 in the primary, it is not the same as 5.0 from secondary. In the differences there will be a "Qty" : "5.0" value. The cell will have a blue rectangle.
primarySourceExportData
The data, after export rules have run, that will be sent to the Primary Data Source. You can see the exported value by hovering over a cell or opening the Cell Rules Panel
secondarySourceExportData
The data, after export rules have run, that will be sent to the Secondary Data Source. You can see the exported value by hovering over a cell or opening the Cell Rules Panel
Example
To access the rowData 's differences parameter in a script, use
if ('material' in rowData.differences)
{
// do something
}Last updated