The following expressions and symbols can be used in free text searches:
AND / plus ‘+’
Example: water and sanitation
Example: water + sanitation
The search will return records with both ‘water’ and ‘sanitation’.
Note: If no expression or symbol is put between terms ‘AND’ is assumed. For example: ‘water sanitation’ is understood as ‘water AND sanitation’.
OR / Vertical bar ‘|’
Example: water or sanitation
Example: water | sanitation
The search will return records with either ‘water’ or ‘sanitation’ or both ‘water’ and ‘sanitation’.
NOT / Exclamation mark ‘!’ or minus ‘-’
Example: water -sanitation
Example: water !sanitation
Example: water NOT sanitation
The search will return records with the word ‘water’, but not the word ‘sanitation’.
Double quote " "
Example: "water sanitation"
Document must be an exact phrase. They must contain the words 'water' and 'sanitation' adjacently in any field in a document.
Round brackets ‘()’
Example: (water|sanitation) AND (irrigation|drainage)
Document must contain either water or sanitation AND either irrigation or drainage.
Document containing keyword variations: finance, financial, finances, etc.
Example complex search: "water sanitation" -(irrigation|drainage)
Document must contain the words 'water' and 'sanitation' adjacently in any field in a document, but not contain either 'irrigation' or 'drainage'.
Note: It is not possible to use single words in combination with the negative expressions and symbols, such as ‘|’, ‘OR’, ‘NOT’, ‘-’, ‘!’. So a query that just contains ‘-water’ would not be acceptable. It would be acceptable to put ‘sanitation -water’