DB Listing
- Last UpdatedAug 14, 2025
- 3 minute read
The DB Listing window allows you to query and output aspects of the database for example to report changes since a certain date.
Destination
You can send the output of queries to a File or Screen. If File is selected, enter a valid path and filename.
If Screen has been selected, the result is the output to a standard Command Window when Apply is clicked.
Select New File to create a new file to output the result to. Select Overwrite or Append if the file exists.
Browse displays a file browser allowing a previously created output file to be used as the destination.
Elements
The Elements part of the window lists elements that is reported on when Apply is clicked.
Click on any element in the list to navigate to that element in the Catalog Explorer.
The active field in the Changes Since pane depends on the mode (Changes, Listing or Difference). None of the controls are active in DB Listing mode. In DB Changes and DB Differences modes, the following options can be selected:
|
Savework |
Reports on changes since the last Save Work. |
|
TimeDate |
Reports on changes since a given time and date. The time format is specified as HH:MM on a 24 hour clock, for example 16:15. The date format is DD MMM YYYY, for example 9 Feb 1998 or 30 Aug 97. |
|
Session |
Reports on changes since the given session number. Input a session number or use the plus and minus (+/-) options to increment the session number. |
|
Extract |
Only active when the current element is in an extract database. When this option is chosen, the options in the Since Extract frame becomes active. Type in the session number, or change it using the + and - options. |
|
Stamp |
Reports on the changes since the Stamp selected from the Since Stamp list at the bottom of the window. Remember that each DB has its own sessions. The current DB is displayed by Database Name at the bottom of the frame. |
Note:
Time Date and Session are related, changing one affects the other settings, and also
display the correct Session User.
Click More to open a window that displays the Database Name, Reason for session (such as a Save Work), the Session No (the session number) and any Comments associated with the Session.
Changes Since Extract
The first drop-down list in the Extract frame displays all the databases in the extract hierarchy above the current extract, with the Master at the top of the list.
The options on the next drop-down list are:
|
Only |
Compares the current database with the selected extract ancestor database. |
|
Latest |
Compares the database with the latest version of the selected extract ancestor database. |
|
Session |
Compares the database with the selected ancestor extract since session nn of that extract. |
|
Date |
Compares the database with the selected ancestor extract since the given date in a session of the ancestor extract. |
Changes Since Stamp
The Since Stamp part of the window is only available if the Stamp option has been selected (see above). Select the Display drop-down to list Stamps by; Name, Date, Function or Description.
Highlight Changes
The Highlight Changes option is only active when the window is in DB Changes or DB Differences mode with a DESIGN database selected. If switched on, the changed elements is highlighted in all the 3D graphics views in the color specified by Colour > Changes. The Highlight Changes option is useful after a Get Work to view the changes that other users have made.
Apply is only active when there are elements in the Elements list.
Cancel exits the window and clears the Elements list.