JBoss.orgCommunity Documentation

Chapter 12. Searching

12.1. Finding Model Objects
12.2. Search Models Via Relationship Properties
12.3. Search Transformation SQL
12.4. Search Models Via Metadata Properties

Designer provides multiple search actions located via Teiid Designer sub-menu in Eclipses Search menu. Search menu.

Search Options

Figure 12.1. Search Options


The Teiid Designer provides a name-based search capability to quickly locate and display model objects.

The Teiid Designer provides a search capability to find model objects that are characterized by one or more relationship property values including relationship type, participants and name.

The Teiid Designer provides a search capability to string values present in transformation SQL text.

You can select individual objects and view the SQL. If a table or view supports updates and there is insert, update or delete SQL present, you can expand the object and select the individual SQL type as shown below.


If you wish to view the selected object and its SQL in a Model Editor, you can click the Edit button. An editor will be opened if not already open. If an editor is open its tab will be selected. In addition, the Transformation Editor will be opened and you can perform Find/Replace (Ctrl-F) actions to highlight your original searched text string and edit your SQL if you wish.

The Teiid Designer provides a search capability to find model objects that are characterized by one or more metadata property values.