DDO / Filters Tab Page
This tab page serves two purposes. The upper part is reserved to show a list with the tables that were opened by Database Explorer and where a DataDictionary object was created for. The information is shown in a tree view style.
Parent / Child Tables
By default, Database Explorer only opens the selected table. You can configure the tool to also open all parent and/or all child tables.
- Opening Parent Tables: This has the advantage that you cannot enter a non-existing foreign key value in a child table column.
- Opening Child Tables: This prevents you from deleting records when the child tables have records that relate to the delete candidate record.
When parent and/or child tables are opened, the tree view will show the main table along with the parent and child tables in a hierarchical manner. Tables that are not opened can be opened/added here via a right mouse click on any of the table tree view nodes. In the floating menu, you can select: - Add Parent Tables - Add Child Tables
The columns of the current table are enumerated for relationship information, and if any relate, the parent tables will be opened. The file list is enumerated, and all child tables are queried to see if any relate to the current table. If so, the table remains open, a DataDictionary object is created, and the table name is listed in this tree view.
If filters are defined for any of the tables, the tree view node for the table with a filter shows the text “(Number of filters defined: nn)”.
Filters
The second half of this tab page shows a grid in which we display the defined filters for the current data view. With filters, it is possible to work with a limited set of records in the data view. A right mouse click in the grid brings up a floating menu in which you can choose between: - Add - Delete - Edit - Delete All Inactive Filters
Filters can be active or inactive. Only active filters limit the number of records shown. All changes made to the filters are automatically enforced.
SQL Filter
In the case of an SQL table, it is possible to enter a filter criteria string and turn the use on/off.
Enter a string like customername like '%ss%' to get all rows from a customer table where the name contains two "s" characters.