Create User Stamp and Update User Stamp

[Former Member]

Hello

Is there a way to track the User ID who creates a record and also track the last User ID to update the same record? The only field type is USER STAMP so I do not see a way to track both users. When I choose USER STAMP, the Writable Once options is grayed out and changed to No.

Create User ID = 123. This ID should coordinate with the CREAT STAMP data and time

Last Update User ID = 789. This ID should coordinate with the TIME STAMP data and time

thanks

Tammi

[Former Member · Accepted solution]

Hi Tammi,

Change Tracking is definitely a best solution to track the changes, no doubt about that. but the problem with chnage tracking is that it requires lot of memory and it hampers the performance of MDM server.

So, if your requirement is only to know the user who created the record and the last user who changed the record; then there can be a workaround which will definitely solve your problem.

Try these steps:

1. First create two fields in the repository say Created By and Last Updated By. First field will be of type Text and second field will be of type User Stamp.

2. Now in Data Manager, create an assignment which will assign the value of Last Updated By to Created By.

3. Now create a workflow which will trigger, everytime new record gets added into repository and call this assignment in that workflow.

4. So everytime you create a record, user Id of creator will gets stored in Created By field and next time when you update the same record that user ID will gets stored in Last Updated by field.

This should work. Please let us know if problem still persists.

Regards,

Varun

[michael_theis]

Hi Tammi,

in addition to the proposals above, there's a different one. If you use an Auto ID field in your repository main table, you could do the following. Create a field "created by" of type "user stamp". Set the field's properties "Selected Fields" to your Auto ID field. The selected fields property defines the fields that trigger the change of the user stamp. Defining the Auto ID field there, you can create a user stamp that only changes if the Auto ID changes. Note that there are some situations (e.g. a record merge) where this could be the case. You can to the same for the create stamp, too.

Best regards

Michael

[Former Member]

Hello,

you have to activate the change tracking No -> Yes in

MDM Console / Admin / Change Tracking / Change Tracking Details

for the tracked data

You need :

-have the admin role

-unload the repository to make change

Regards

Vincent