Forums
Infor Global HR (GHR)
What table contains CHANGEDFIELDS
Author
Messages
TimC
Veteran Member
Posts: 84
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
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%'