Data log report

Srinivas Thota

Certified Lead Developer

over 6 years ago

hi,
i having a requirement to capture the log report of data and show up in a grid, it contains the present data, date of data entered and updated date and updated data,
i need capture all the data as like metadata, and visible to enduser

Thank you
i am looking for some hep to complete this task, Does appian support this kind of task

warm regards
srinivas

Discussion posts and replies are publicly visible

Parents

0 harrisont606 over 6 years ago

Hi, you can accomplish this with a trigger populated history table. Create a history table with columns you listed, and then update your original table with triggers for edit/insert/delete/update so that any change is inserted into the history table. Once that is done you can make a CDT for the history table and display it in a paging grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 harrisont606 over 6 years ago

Hi, you can accomplish this with a trigger populated history table. Create a history table with columns you listed, and then update your original table with triggers for edit/insert/delete/update so that any change is inserted into the history table. Once that is done you can make a CDT for the history table and display it in a paging grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data