Business Rule - Updated by Field

[mateusz3]

Hi Guys.

I have a small problem with the Updated by field.

My company has implemented a single sign on, and we had to update the user id field to a unique reference number for our company.

I think the best way would be to implement a business rule for when the updated by field meets the patern to, but I am unable to find the correct field.

Ideally I would like that field to populate the name of the user that is updating the incident form.

Anyone has an idea how the script should look ? (I am quite neewbe in SN...no it experiance)

Thanks in advance

Matt

[Goran WitchDoc]

Hi Matt,

I would think twice of starting to mess with the updated by field. It's not a "normal" reference field and the same goes for "created by". The name that is placed here is first name & last name. So if you want to fiddle with it, perhaps it how you store data in these fields, other than that, I wouldn't go into that djungle, might not find your way out again.

//Göran

[mateusz3]

Hmm ok,

Any ideas as the Updated by shows always the user id, which looks like that in my instance.

I need the field to show me the name or cws, Our performance reporting needs to go by that updated by field. And the User Id is not very user friendly.

[Goran WitchDoc]

Hmm.. sometimes it isn't a good thing writing replies in the middle of the night. Your're right, it does show the userID instead of what I thought without checking. I just realized that we used "opened_by" field on the reports and not created_by which gives the userID.

In this case I still wouldn't wanna mess with updated_by, if there isn't a way around the reports like for example going for the assignee instead I would create a new reference field and a BR that takes the userID from the record, looks it up in the usertable and fills in the new field. Then the reports would use that field instead of the updated_by.

Just remember that in some cases updated_by would for example have "system" as data. For example if you use the OOB functionality that change the state from resolved to closed on incidents after a set of days, then the updated_by is "system".

Sorry for the midnight answer.

//Göran

[mateusz3]

''

create a new reference field and a BR that takes the userID from the record, looks it up in the usertable and fills in the new field. Then the reports would use that field instead of the updated_by.

''

Sorry bit of a newbie, would the new ref field go into the incident table?