USERFIELD_STORAGE Business Class

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 - YOU ARE CORRECT. I was able to find my field Employee BC.


Thanks a lot.

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

(response copied from post https://www.lawsonguru.co...export-table/#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