|
|
SELECT
ld.ObjectLogDetailID,
ld.ObjectLogID,
ld.OperationID,
ld.LevelID,
ld.PropertyName,
ld.PropertyType,
ld.PropertyValue,
l.Name AS ObjectName,
l.ObjectType AS ObjectType,
op.[User],
op.TimeStamp AS LastModified,
op.KeyValue,
lev.Description AS [Level]
FROM {0}ObjectLogDetails ld
LEFT JOIN {0}ObjectLogs l ON l.ObjectLogID = ld.ObjectLogID
LEFT JOIN {0}Operations op ON op.OperaionID = ld.OperationID
LEFT JOIN {0}Levels lev ON lev.LevelID = ld.LevelID
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Submit an article or tip