INFOR.COMPASSTIMESTAMP

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 may specify an alias to override the default result set column name.

Syntax

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.

Syntax

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. The infor prefix is the new naming standard as of v2020-09. The infor prefix was added to avoid name contention with properties defined in the object meta data. You may continue to select the timestamp using autogenerated_timestamp, but it may be depreciated in a future release.