Data Dictionary Maintenance

Filtering the Table Names Lookup

The Lookup Table Names dialog displays a tree view list of all table names in the data dictionary according to Group. This dialog is launched when clicking the Query Table View button (magnifying glass) to search for a table name, as in Data Dictionary Maintenance for example.

This list can be filtered by Table Name, Table Description, Column Name or File Type to make it easier to locate a specific table name.

(Support to filter by Table Name, Table Description or Column Name was added in PxPlus 2018.)
(Support to filter by File Type was added in PxPlus 2023 Update 1.)

The Lookup Table Names dialog consists of the following:

(Tree View)

Initially displays a list of all tables, including descriptions, in the data dictionary according to Group. Any tables not assigned to a particular Group are listed under -none- in the tree view.

A file type icon precedes each listed table name. To see a list that describes what these icons represent, hover the mouse pointer over the ? button beside the tree view.

(The table descriptions were added in PxPlus 2023.)
(The file type icons were added in PxPlus 2023 Update 1.)

File Type Icons

Button (beside the tree view) that displays a floating tip with a list of file type icons and their descriptions.

(The ? button was added in PxPlus 2023 Update 1.)

Filter By

Used to define the filter criteria to be applied to the list of table names. Filter selections are Table Name (Default), Table Description, Column Name (name of data element), and File Type.

When filtering by Table Name, Table Description or Column Name, available operands are Contains (Default), Equals, Starts with or Ends with. Enter a filter value in the adjacent input control.

When filtering by File Type, available types are Native (PxPlus) file, Prefix (database Prefix file), Link (database Link file) or Unknown (no file defined). Selecting either Prefix or Link displays a drop box for selecting a database type: All Databases (Default), ODB, MySQL, ADO, DB2 or OCI.

(Support to filter by File Type was added in PxPlus 2023 Update 1.)

Apply

Button that applies the defined filter criteria to the list of table names.

Reset

(Available only when a Filter is applied)

Clears the filter value entered and reloads the list of table names.

Collapse All
(Expand All)

Toggle button that collapses (or expands) all the groups listed in the tree view to display the table names assigned to each group.

OK

Selects the highlighted table name.

Cancel

Closes the Lookup Table Names dialog.