For the complex search of metadata and user data, you use the dynamic search screen. After the entry of a main entity, you can collect individual search lists and search for data about, for instance, multiple connected entities in the data model. | |
![]() |
Searching |
|
|
![]() |
The cross-entity search is not available on the Web client. |
Creation of an individual search list |
|
![]() |
Select |
To start the search, you must first enter the name of the main entity. The main entity for one or more search lists is the entity which is the starting point in the data model or whose master table is the one which will supply the unknown data to be searched through. | |
![]() |
Click the ![]() |
![]() |
Enter the title of the main entity in the | field.
![]() |
Click the ![]() The default master list of the main entity appears. This is a template and cannot be modified. |
![]() |
Select New
from the context menu in the form header and enter a name for a new search
list in the input screen. (It doesn't matter what name). |
![]() |
Remove unnecessary fields/columns from the
search list by holding the mouse button first and pressing [Ctrl+Shift]
simultaneously to mark a column and drag it onto the desktop. Important fields of the main entity cannot be removed. |
![]() |
Add new fields/columns into the search list
by marking the fields/columns in any source screen and dragging them into
the desired position in the search list. Search screens can be Agile e6 system forms for searching for metadata and any user screens when searching for user data. Note the rules for the construction of search lists. |
![]() |
Search for data with the standard function Search. |
Further processing of search results |
|
Search results in search lists can optionally be dragged and dropped in screens which show the master table of the main entity. This allows you to immediately understand the records you find, and edit them. Data, which is already included in the target mask, will be deleted after the drag and drop operation. | |
Saving search lists |
|
Agile e6 does not
save search lists created for a main entity in the Repository, but rather
in a user-specific file in the <frm> directory on the
server. After closing and reopening of a search screen and loading of the
main entity, all search lists created for this main entry will once again
be available. |
|
Rules for the creation of search lists |
|
The selection of the main entity, of fields/columns in a search list as well as their order determine the set-up of the WHERE clause for the SELECT statement which Agile e6 uses in the search. Note the following rules for the construction of search lists.
When creating a search list, always select that entity as main entity whose master table contains the unknown data you are searching for. |
|
Selection of search fields/columns |
|
For the first field, always select a significant field of the main entity. If the search extends over several related entities in the data model, the search list must always contain at least one significant field of the participating entities. The order of significant fields in the search list must correspond to the order in which the participating entities are connected in the data model. If two entities in the data model are connected over a connection, you don't necessarily have to add the corresponding key fields to the search list. Agile e6 will recognize it on its own. If the data model has multiple connections leading out from one entity, however, then you must decide which connection the search will follow, and include the corresponding key fields. If you do not, Agile e6 will always use the first connection defined in the entity. |
|
Application-specific invocation of the search screen |
|
The invocation of a search screen from the application is done using iwf_frm_ent ENTITY USRMGN_FORM. | |
Search screen example |
|
You have already created screens with context menus, for instance during application development. Now you want to find all screens whose Select menu contains an Edit item. The search is executed in the Agile e6 data model over the system entities (screen data), (Menu data) and (selection data). Select screen data as the main entity, since this is the master table you want to retrieve data about. In a new search list, you first add the necessary significant fields of the participating entities in the order given by the data model. Additionally, the key must be inserted after the screen name, so that the search will execute over the Screen-Select-Menu connection and not over one of the other six possible connections between screens and menu/button areas. The addition of the attribute field is optional and in this case allows entry of the search criterion. If you also would like to see the titles of the screens found, you could insert the attribute field between the screen name and . | |
![]() |