PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/20/2017 9:03 AM by  TimC
What table contains CHANGEDFIELDS
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
TimC
Systems Analyst
Private
Veteran Member
(220 points)
Veteran Member
Posts:84


Send Message:

--
06/19/2017 1: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
    Systems Analyst
    Private
    Veteran Member
    (220 points)
    Veteran Member
    Posts:84


    Send Message:

    --
    06/20/2017 9:03 AM
    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.