Audit table

We have a requirement where we need to retrieve the column name whose value was changed in a particular action.

Could someone help me with it.

 

Thanks in advance

  Discussion posts and replies are publicly visible

Parents Reply
  • Or you can try this : 

    Prepare a expression rule like below : 

    rule!FormDifferenceData

    {

    local!oldCDT : CDT_Type(

    field 1 : old value

    field 2 : old value

    field 3 : old value

    ),

    local!newCDT : CDT_Type(

    field 1 : updated value

    field 2 : updated value

    field 3 : updated value

    ),

    local!difference : cdtdifference(
    local!oldCDT,
    local!newCDT
    ),

    local!difference

    }

    *This will work for fields of a nested CDT.

Children