Adding a simple search option
In the context toolbar above the result set view in Axiell Collections, you have the option to quickly execute a new search by selecting a field from the Quick search drop-down list of all indexed fields in this database, after which you simply enter your partial (explicit truncation required) or whole search key in the Search term box and click the magnifying glass.
On top of the full list of indexed fields, you can add a Simple search option which can search multiple indexed fields at once (always with implicit left and right truncation).
You must set it up per desired data source in your (.pbk) application definition in the Designer Application browser, as follows:
| 1. | In the tree view on the left, open the data source to which you'd like to add this simple search option. |
| 2. | Right-click the Methods list header and select New > Method in the pop-up menu. |
| 3. | On the Method properties tab, for Method type, select Simple search. |
| 4. | In the Menu texts box enter the name for this new access point which will be visible in the user interface between < and > at the top of the list of indexed fields. Name it Simple search, for example. Add as many translations as are required by the users of your application. |
| 5. | At the bottom of this properties tab, in the Simple search fields box, enter one or more field tags (one tag per line) for which an index exists. (These indexes may in turn index just a single field or multiple fields.) The field tags do not need to be of the same data type but they need to be either indexed on Text, Free text or Alphanumeric. For linked fields, their lookup fields need to have such indexes in the linked database table. There's no comfortable way here to look up the tags you need, so you'll have to do that in the database table definition. |
| 6. | Save your changes in the application definition. |
| 7. | Recycle your Axiell Collections IIS application pool when nobody is using Collections, to make the changes become visible in Axiell Collections. |
Once the <Simple search> option is available in the Quick search drop-down list, Collections users can also include it as an access point on the Standard search tab for the current data source, via the Settings in the Standard search.
Do note that the implicitly executed query displayed in the Collections status bar after your simple search, may not list all tags that you provided and instead of all the missing tags search an unknown tag aa: this tag aa however, is just a dummy tag to represent a search in all non-linked full text indexed tags together. So all indexed tags you provided for this method (with the supported index types) will indeed be searched.
Feedback
