Finding records: Detailed Search

Detailed searches can be carried out in the Projects, Sub-Projects, Quotes Clients and Translators sections.

An alternative method that is the QuickSearch function, which is available in almost all program sections.

Translators in particular can be found using Filter search.


In Detailed Searches you will be directed to a separate screen to enter search criteria.



Finding records that match two or more criteria

Enter all search criteria that you want to combine, e.g. client name and target language (sub-project); click on Perform Search to have TOM search all records matching all criteria.

Finding records that match one OR another criterion

Example: You want to find the projects of two clients, AB AND XY.

Enter "AB" in the field 'Client'.
Click Add FIND request  and enter "XY" in the field 'Client'.
Click Perform Search  to have TOM search all records matching one OR the other criterion.

'Omit' in search

This option lets TOM find all records that do NOT match the given criteria. E.g., to find all projects without English as a source language enter "EN" (or whatever language code you use) as a source language, check the reverse search checkbox and click  Perform search .

If you want to combine a standard and an 'omit' search (e.g. all projects that have an order value of 50 EUR min., excluding those with English as a source language) just add the reverse search as another FIND request.

Enter " >50 " in the Price field
Click Add FIND request
Enter "EN" (or whatever language code you use) as a source language, check the reverse search checkbox and check the option Perform Search.


Search types: Standard - Restrict - Extend

There are three ways in which TOM can carry out a search request:

Standard search: includes all records existing in the database and the result will replace any currently found set of records.
When checking the Restrict to Found set option: if 100 records are currently listed the search criteria will be applied to those 100 only
When checking the Extend Found set option: The found records will be added to the set of currently called-up records


Search operators

Many search operators can be found in TOM's search screens.

Below are some more useful search operators and combinations.

To find ranges of data use these:



Date operators: