Prev
Next
Forums Lawson Landmark

USERFIELD modify history (EXPORT table)?

Sort:
You are not authorized to post a reply.
Author
Messages
TimC
Veteran Member
Posts: 84
Veteran Member
12/20/2016 6:33 PM

    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
    12/20/2016 8:26 PM
      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
      12/21/2016 12:17 PM
        Thanks Kelly.
        Merry Christmas.
        You are not authorized to post a reply.