EaSearches - Helmut-Ortmann/EnterpriseArchitect_hoTools GitHub Wiki
Searches
In most projects, there are a lot of Searches - partly deep hidden in EA menus.
Find searches and execute it from hoTools with minimum effort and at one location:
- Toolbar, (e.g.F1, Q, S)
- Enter Search Name, Autocomplete
- Enter Search Name, Fuzzy find Search
- Enter Search Term and press 'Enter'
- Double Click in Search Term to enter Clipboard Content and run the Search
- Export Result to Excel, csv
- Standard Searches
Inventory
hoTools inventories Searches to easily find them at one place. The sources are:
- EA Searches defined by hoTools in 'EAStandardSearches.json' (installation folder)
- MDGs
- Personal Searches of EA (my)
- SQL searches defined by SQL path
- LINQPad searches defined by LINQPad path
- Standard Searches
Define Searches
You can define Searches by:
- EA Search
- LINQPad
- SQL Search hoTools SQL development environment
- Standard Searches
All SQL Searches and the <Search Term> allow using wild card. hoTools automatically transforms the wild card into the one supported by your DB (database).
Run Searches
You can run Searches by Button in Toolbar and Global Keys:
- EA Searches
- hoTools SQL queries (in fact a *.sql file which is in the SQL path (see Settings SQL) )
Run Searches Example
- One Click on F, Q, or S runs the Search with the Search Term 'myFunction'
- Enter in Quick Search runs the Search 'Quick Search'
- Enter in myFunction runs the Search 'Quick Search'
- Left Double Click in myFunction inserts the Clipboard and runs the Search 'Quick Search'
Quick Search
With Quick Search you can insert your string to search and press Enter.
Define Search
For a Search you can define in the context of Toolbar or Global Keys:
- The caption of Button to show in Toolbar
- Tooltip to show in Toolbar
- Search
- EA Search Name (has to be a valid EA Search)
- SQL file name (*.sql) which is in paths (see Settings SQL)
- <Search Term> (The text which replaces <Search Term> at run time (as you know from EA))
- e.g. 'My*' for a SQL like a statement
- Note: hoTools SQL files handles wildcards for you (*,%,..)
Toolbar with Search
Find a SQL Search
You can define the SQL file by:
- SQL file name with 'mySearch.sql' (set the SQL Path in Settings)
- SQL file name with path like 'c:....\mySearch.sql'