This function shows the Compass timestamp of the data object for the record. It is associated with the Compass record.

The functions and parameters are case-insensitive. The default result set column name is infor.CompassTimestamp. You can specify an alias to override the default result set column name.


select infor.compasstimestamp('object') from object

The parameter is the object name. Use single quotes around the object name because it is a literal for the function. Use the object name as a parameter if the query contains joins to select the CompassTimestamp from a specific object name.


select infor.compasstimestamp() from object

The object name is optional if the query selects data from a single object.

Note: Before v2020-09, the default name of the Compass timestamp was autogenerated_timestamp, this is now deprecated.