What is Last Updated At and By field?
You can track changes at the row level using the two columns – 'Last updated at' and 'Last updated by' which capture metadata for changes in the data input columns.
These are enabled once you add a data input column and can be found in the data input dropdown. Select/deselect to show/hide columns. They can also be enabled/disabled from the ‘Manage columns’ dropdown.
For more information , refer Writeback Matrix features | Inforiver
Possible to writeback these two columns?
We can’t writeback directly to the Last updated At and Last Updated By field, as these are Visual fields.
How to writeback these columns to the database?
In order to capture this data, we need to create a Text Data Input column with reference to these fields.
Steps to follow :
1. Create UpdateBy_Text and UpdateAt_Text data input column
2. Next, go to the Data Input Column where the value is expected to change.
In this section, you'll need to update the On Change Formula.
SETVALUE([UpdateBy_Text],LAST_UPDATED_BY)
SETVALUE([UpdateAt_Text],DATE.SET(LAST_UPDATED_AT,'DD/MM/YYYY hh:mm'))
3. Now doing any change in the Number column will update the UpdateBy_Text and UpdateAt_Text
4. Now you can select the DI columns to writeback
Frequently Asked Questions
1. Are the two fields, LastUpdateBY and AT, available in the Reporting Matrix?
Ans: No. These fields require login details and are only available in the Writeback Matrix and EDITable.
2. Can we use the same steps to write back these two audit data input columns in the Editable matrix?
Ans: No. The same steps cannot be used, instead please refer Editable – Logging and Writeback Last Updated Metadata to database.
3. Will it reflect changes made in slicer selections?
Ans. Yes
