By default, Aptify's Basic Find dialog searches for a record within a service based on the record's name (the first Is Name field in the entity's field sequence) or ID. Alternatively, Aptify allows an administrator to configure a different field or full text search to be used as the basic search items.
To support this functionality, Aptify includes the FindBasicSearchItemsToSearch attribute (which can be added to the Configuration > Attributes tab of any entity) to control which items (fields or full text indexes) are searched when using the Basic Find dialog. The value for this new attribute is an XML fragment and must be entered using the following syntax:
| Code Block | ||
|---|---|---|
| ||
<ItemsToSearch> |
...
<Item Name="Name1" FilterType= "FilterType1" Operator= "Operator1"/> |
...
<Item Name="Name2" FilterType= "FilterType2" Operator= "Operator2"/> |
...
</ItemsToSearch> |
Within the ItemsToSearch element, any number of elements can be defined. The Item Name element has 3 three defined attributes:
- Name: The name of the Field field or the display name of the Full Text Index Filter, depending on the value of FilterType. The value for this attribute must match a field or full text index filter in the entity. This is a required attribute.
- FilterType: The type of filter. This is a required attribute. The following options are available:
- Field: The value in the Name attribute must match the name of an entity Field within the entity.
- FullTextIndex: The value in the Name attribute must match the display name of a Full Text Index Filter defined on the entity.
- Operator: Defines the operator to use in the search. The value of this attribute must match the English language (default) text for an Operator that is supported for the field or full text filter that is being searched. For numeric fields, the numeric operators (like =, < and >) can also be used. This is a required attribute. The available operators are dependent upon the value of the FilterType (field or full text index) and the type of field (text, numeric and bit).
...
- Is True: Bit is set to 1.
- Is False: Bit is set to 0.
Example
For example, for the Persons service, you could define the following two search items to search on when the Basic find dialog is launched from the Persons service. The first item searches the Country field of the Persons records and returns those that begin with the value entered in Basic Find dialog. The second item searches the full text index that is defined on the Persons entity to search address lines. If an address line contains the value entered in the Basic Find dialog, it will be returned.
| Code Block | ||
|---|---|---|
| ||
<ItemsToSearch> |
...
<Item Name="Name" FilterType="Field" Operator="Begins With"/> |
...
<Item Name="Status" FilterType="FullTextIndex" Operator="Contains" Value="Approved"/> |
...
</ItemsToSearch> |
...