SmartMarine 3D - Show recent objects in the work space

| | | |

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.

Smart Marine 3D beginners SQL quick start

| | | |

Some simple SQL queries that can help new users start faster.

Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.

Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database - XXXX_MDB. The table view JNamedItem contain all items names and their IDs - oid. The equipment data is read from JEquipment. Table view JEquipment has information for the equipment ID but not for its name.