• Search Forums
    Advanced Search
Prev
Next
Forums Human Capital Management Infor Global HR (GHR)

What table contains CHANGEDFIELDS

 1 Replies
 0 Subscribed to this topic
 47 Subscribed to this forum
Sort:
Author
Messages
TimC
Veteran Member
Posts: 84
Veteran Member
6/19/2017 5:55 PM
I need to query the export tables and need the CHANGEDFIELDS field as it doesn't exists on the ...EXPORT tables (WorkassignmentExport, EmployeeExport. What tables correlate that I can join to fetch this field?

Landmark V10.
TimC
Veteran Member
Posts: 84
Veteran Member
6/20/2017 1:03 PM
I figured it out. This is the SQL Server version

SELECT t.name,c.name
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%CHANGEDFIELDS%'