PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/21/2016 7:17 AM by  TimC
USERFIELD modify history (EXPORT table)?
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
TimC
Systems Analyst
Private
Veteran Member
(220 points)
Veteran Member
Posts:84


Send Message:

--
12/20/2016 1: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
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    12/20/2016 3: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
    Systems Analyst
    Private
    Veteran Member
    (220 points)
    Veteran Member
    Posts:84


    Send Message:

    --
    12/21/2016 7:17 AM
    Thanks Kelly.
    Merry Christmas.
    You are not authorized to post a reply.