What table contains CHANGEDFIELDS

Sort:
You are not authorized to post a reply.
Author
Messages
TimC
Veteran Member
Posts: 84
Veteran Member
    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
      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%'
      You are not authorized to post a reply.