PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/20/2016 3:27 PM by  Woozy
USERFIELD_STORAGE Business Class
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Srini Rao
Private
Private
Veteran Member
(287 points)
Veteran Member
Posts:133


Send Message:

--
06/01/2016 11:45 AM

    I'm need to extract the data from USERFIELD_STORAGE business class , but I;m not finding this business class in landmark transaction builder. But I can access the table using SQL.

     

    In which module this business class resides?



    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    06/01/2016 2:33 PM
    Hi Srini Rao,

    That table isn't actually a business class, but is a db table that is related to all the business classes. I don't think you can access it via the Landmark tools directly. Instead, you just query the linked business class and include the userfield in the list. So if you have a userfield named "MyField" on the "Employee" business class, then you would query Employee and include MyField in the field list.

    You can query the UserField business class in the Repository module to get a list of the configured UserFields, but not the related values.

    I hope this helps.
    Kelly

    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Srini Rao
    Private
    Private
    Veteran Member
    (287 points)
    Veteran Member
    Posts:133


    Send Message:

    --
    06/01/2016 3:26 PM
    Kelly - YOU ARE CORRECT. I was able to find my field Employee BC.


    Thanks a lot.


    TimC
    Systems Analyst
    Private
    Veteran Member
    (220 points)
    Veteran Member
    Posts:84


    Send Message:

    --
    12/20/2016 9:10 AM
    Hello Kelly,

    Our user associated a userfield with the Employee biz class and also with the EmployeeExport table (form). I need to read the history from an SQLQuery node. However, do you know the table relationship to fetch the history to that table? Is there a user field history (export) table.
    So, the query would look something like:

    SELECT e.*, u.*
    FROM EMPLOYEEEXPORT e
    LEFT OUTER JOIN SomeUserfieldHistoryTable u ON e.UNIQUEID = u.FKUNIQUEID
    WHERE e.EMPLOYEE = 12345
    AND u.USERFIELD = 'myuserfield'
    AND e.RECORDSTATUS=1
    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    12/20/2016 3:27 PM
    (response copied from post https://www.lawsonguru.com/forums/p...le/#41802)

    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
    You are not authorized to post a reply.