Value of opened_by is not matching created_by

[tuitendung]

I have a question regarding the sc_req_item table. I noticed that for some tickets, the opened_by and created_by values are not the same. I thought they would always be identical. Could you explain what normally ensures these two values are synchronized when a ticket is created (Business Rule or something else), and what might cause some tickets to have different values (overridden by another Business Rule)?

[Sandeep Rajput]

@tuitendung Both the values are same, the difference lies between the data type of both the fields. Created_by fields captures the string value of user name. Whereas Opened_by is a reference field which captures the sys_id and shows the name field as display field from sys_user table.

In the first row of the screenshot you shared, created_by has abel.tuter populated which is a string value of user_name of Abel Tuter. On other hand Opened_by contains Abel Tuter which is a reference field and shows Name of the User from sys_user table.

Hope this helps.