Assets Database Details View
Use the Details view to display and change the SQL expression that controls the list view and to view and select the Site database that contains the asset details
To display the Details view, click the Details
button in the toolbar.
To choose the asset data you want to display in the List view:
1 By default, the Details view inherits the Site Database settings from the Console. If you want to select data from a different Site Database, enter its Data Source Name in the DSN Name, and enter the details of the account that can be used to access the database in the User ID and User Password fields.
2 In the SQL Code field, enter one or more SQL statements to select the data you want to display.
Alternatively, click SQLWizard to build your statements interactively.
3 Click Execute SQL to select the assets and display them in the List view.
Related Topics