USERFIELD modify history (EXPORT table)?

 2 Replies
 1 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
TimC
Veteran Member Send Private Message
Posts: 84
Veteran Member

I have a scenario where a USERFIELD is linked to the EMPLOYEEEXPORT table (form). I need to fetch the userfield's update history. I don't see a USERFIELD_STORAGE_EXPORT type of table. How do I check the history of USERFIELD updates?

I am using an SQLQUERY node to fetch the data as processing is not occurring via a flow.  So, I need the table relationships.

I have the EEID.

 

Thanks much!!

Merry Christmas.

 

Tim

Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
Hi TimC, Unfortunately, as far as I know there is no history stored for UserField values. If there was such a table, it would be S_USFS (based on table prefix of USFS) - but that table doesn't exist, at least on our system (LM10.1.1.19) Hopefully someone can tell me I'm wrong! Kelly
Kelly Meade
J. R. Simplot Company
Boise, ID
TimC
Veteran Member Send Private Message
Posts: 84
Veteran Member
Thanks Kelly. Merry Christmas.