Record Info shows modified date time

(0) Share

Report

Posted on by ThivaKar

931

Hi all,

UserInfo table does not have Modified By and Modified Date Time property turned on.
But when you change something in the Users form and you click on Record Info -> Show all fields, there is a modified by and modified date and time field which is populated correctly.

How is this possible, if the property hasn't been enabled?

Any suggestions.

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's a system table and therefore it can be implemented by any way - it's not the same thing as as normal tables. For example, the system table UtilElements is not a table at all - it's actually backed by a system view.

I could easily imagine that the table has ModifiedBy and ModifiedDateTime fields despite the fact that it isn't shown in AOT. Nevertheless such fields don't exist in UserInfo table in database at all, therefore the values comes from some other source. I don't know what it is.

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report
Copy link

Link copied!

Also, i noticed that if i delete the _ShowAllRecords_UserInfo from my usage data, i could not able not see the ModifiedBy and ModifiedDateTime values again.

Anyway, is there a way to get these record in store it in someother table?

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI Rusty,

They are system field. Such as created/modified by, created/modified date stamp are handled in kernel. You can't even see them.

When you clear usage data,it will clear everything except personalizations. So for your new user, Modified By no longer exists.

Was this reply helpful? Yes No