Object search

Object search in the changes table

The most convenient way of searching the objects in the changes table is the search box above the changes list.

_images/search.png

The search is conducted by the names of the objects. When RegEx is ticked off, the search is conducted with the use of regular expressions.

To start with, just enter a part of the name into the search box. The objects satisfying this condition will be displayed in the changes table.

The search box stores the last 200 entries.

Object filters

To filter the objects, you can use the dialog window which will appear after you click empty_filter above the changes filter.

_images/filters.png

The object type list allows to display only selected types of objects. Selecting the TABLE or VIEW types will display all the descendant objects.

The changes type list allows to display only the selected types of changes.

Filter by object’s SQL code searches for matches in the object generation code.

Search by container searches for the objects located in the schemas with appropriate names. Schema objeсts will be displayed as well.

Search by database user searches for matches in the authors of object changes in the thirdparty database. The pg_dbo_timestamp extension is necessary for work.

Search by git user searches for matches in the authors of the latest object change in local repository. This can be used if the project is under the version control system.

Show only local changes displays the changes that took place in local repository after the last commit. This can be used if the project is under the version control system.

Hide lbrary objects hides the objects downloaded from libraries.

To apply the filters, click ОK.

To cancel current changes, click Cancel.

To reset all the filters, click Reset.

When the filter is on, the button icon will change to filter_tsk.