USERFIELD modify history (EXPORT table)?

 2 Replies
 1 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
TimC
Veteran Member
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
    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
      Posts: 84
      Veteran Member
        Thanks Kelly.
        Merry Christmas.