how to get record's Activities's value

panda1
Kilo Guru

find_real_file.png

 

I want to get the value of the red line in the picture,I don't even know which field he is

This is the record of the sysapproval table

look forward to your help,Thank you.

2 REPLIES 2

Z_Lawrence
Tera Expert

Hi Panda, 

Activity is stored in sys_history_line TABLE. Also if you would like to get more info, please check this link:
Re: Where is the users activity filter stored?

--Zoltan

hi,

Thank you for your help. There is the information I want,

But this table stores all the history,I just want the records filtered by activity. What should I do

Can the information stored here be obtained in a specific format like the journal type field

like this:

2022-01-05 19:09:53 - admin (Work notes)
test