Advanced Search

This search is based around the query builder below. Simply choose the desired database fields that you wish to search and enter the criteria.
Various methods of filtering the results are available such as CONTAINS, GREATER THAN (>), LESS THAN (<) and IS EMPTY/IS NOT EMPTY and brackets can also be used to split the query up into smaller parts.
For more help using the advanced search, please see the Advanced Search Guide.

Example:

To search for all voyages where a vessel involved has a name CONTAINING the word 'Santa' AND the master's name STARTS WITH either 'Giacomo' OR 'Paolo':
Advance Search Example

Query Builder:

There are two types of field: text and choice.

You can use any combination of text and choice fields to build your query, just use the buttons below to add more fields of the type you want. If you can't find the database field you are after in one type of field, try the other. There is a list of all fields and their field type in the Advanced Search Guide.

Hint

Don't use too many search criteria. Start with one or two, check you are getting results and then refine your search further

Search fields:
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Remove line
Hide row


Number of results per page:

Truncate long text Yes No