Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Create Search Definitions
User-defined searches are created using the Search Builder panel, and are stored in the Program Files directory (not in the project repository).
Access: Edit | Model Search: Options | Manage Searches
Use to:
- Create a search definition using the SQL Editor, Query Builder, or an Add-In Search
How to:
To create a new search definition, follow the steps below:
Step |
Action |
See also |
---|---|---|
1 |
Click on the New Search icon in the toolbar The Create New Search Query dialog displays |
|
2 |
In the Search Name field, type a name for the search |
|
3 |
Select the radio button for the type of search you require:
|
|
4 |
Click on the OK button, and refer to the following table |
|
Search Types:
Search |
Description |
See also |
Query Builder |
Your search definition appears as being selected in the Search drop-down field You can now click on the Add Filter toolbar icon to add filters |
|
SQL Editor |
The Custom SQL dialog displays, enabling you to input your SELECT statement The SQL editor is based on the common Code Editor, and provides an intellisense autocompletion list populated with Enterprise Architect's repository structure; to display the autocompletion list, press ( Ctrl+Spacebar ) Enterprise Architect also enables you to use #xxx# macros as string replacers in WHERE statements, so that the same search can be used by different people in different environments; these macros include:
For all Enterprise Architect functions in which you use a custom SQL statement (such as RTF reporting or Model Views) the statement must return the guid and type of the object found so that Enterprise Architect can search for the selected item in the Project Browser; for example: SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object You can extend the usability of your SQL searches using the aliases CLASSGUID and CLASSTYPE, which enable Enterprise Architect to display the Properties dialog and icon for elements, connectors, attributes or operations, as well as selecting them in the Project Browser Some simple examples for using these aliased fields are provided below:
When you have defined the SELECT statement, click on the Save button to save this search; the search is then available from the Search drop-down list |
|
Add-In Search |
Type in:
Your search is automatically saved and available from the Search drop-down list |
|
Learn More: