Access paramDataSetChanges

I did a trace and saw this in the results

  <paramDataSetChanges>
<paramDataSet name="ds" useDataSetNbr="0">
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="Quoted"><![CDATA[True]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="DateQuoted"><![CDATA[9/27/2018 12:00:00 AM]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="ExpirationDate"><![CDATA[10/11/2018 12:00:00 AM]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="FollowUpDate"><![CDATA[10/2/2018 12:00:00 AM]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="ChangeDescription"><![CDATA[Change]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="CurrencySwitch"><![CDATA[False]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
  <changedValue tableName="QuoteHed" rowState="Modified" rowNum="0" colName="UD_SysRevID"><![CDATA[System.Byte[]]]></changedValue>
  <changedValue tableName="TaxConnectStatus" rowState="Modified" rowNum="0" colName="ETCOffline"><![CDATA[True]]></changedValue>
  <changedValue tableName="TaxConnectStatus" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
</paramDataSet>

Can this information be accessed in a BPM?

Yes.
The specified field has been changed from any to another.
-or-
The specified field of the changed row is equal to expression
-or-
almost any other way :slight_smile:

1 Like

Is there a way to access it through C# code?

YourRow[“RowMod”]

“A” = Added
“U” = Updated

But I do not think there is a state for modified, nor what field is modified

Theoretically, you could GetByID of record in the DB and compare it your row, although I dont think its worth it

It seems like the paramDataSetChanges is a completely different dataset that gets created with the changes to the main dataset (in this case QuoteDataSet). Not sure if that is true or not, just my best guess.

Can the “paramDataSetChanges” be access in C# code?

If i had a guess, I’d say that happens in the BPM, similar to what I described above (the record is probably looked up by sysrowid)

@Bart_Elia any insight on this?

John:

If you are in E9, C# only thru a client customization.

Yes I think you can add adapters to the UD tables and make that work.

This one is in E10, not E9.

An adapter for the paramDataSetChanges?