SmartMarine 3D - Show recent objects in the work space
SMART 3D 2013/12/09 14:48 -
Database platform: MS SQL server Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D) Task: Show in the work space all objects created or edited recently For troubleshooting and for monitoring purposes it is useful sometimes not only to get a list of the objects created or edited recently, but also to show these objects in the work space.
To get the recently edited or created objects using SQL query, create in SM3D (SP3D) SQL based filter and key in the following
select oid from JDObject where datecreated > DATEADD(hour, -5, getdate()) or datelastmodified > DATEADD(hour, -5, getdate())