Is it possible to compare 2 CDT and get only modified field name and value of th

umeshkumarn0148

Certified Senior Developer

over 8 years ago

Is it possible to compare 2 CDT and get only modified field name and value of that CDT. I can compare CDT with = operator and can get index of modified content in cdt in form of {true,false,true....} but cannot get either field/value using that index, For accessing CDT I need to use cdtname.fieldname. I cannot retrieve modified vlaue using cdtname[index]. This is needed to capture audit in database for modified field in CDT. Any pointers to this query is appreciated.

Thank you in advance.

Discussion posts and replies are publicly visible

Parents

0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Umesh, as per your post, it seems you need to do it for auditing, the best way to do it would be to handle this in the trigger / packages in the database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Umesh, as per your post, it seems you need to do it for auditing, the best way to do it would be to handle this in the trigger / packages in the database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data