Crisisworks 4.0.134 — with improved full-text searching

This release contains a new full-text search implementation, which allows users to find records containing certain text phrases, using an extension of MySQL's boolean full-text algorithm described at http://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html - see this page for examples of how boolean operators and wildcards can be used to filter searches.

Here are some examples of search patterns and what they find.

Pattern	Meaning
smit*	Any record containing a word beginning with 'smit'
*mith	Any record containing a word ending with 'mith'
john smith	Any record containing either the word 'john' or the word 'smith'
+john +smith	Any record containing both the words 'john' and 'smith'
"john smith"	Any record containing the phrase 'john smith' (note, double-quotes)
-"john smith"	Any record not containing the phrase 'john smith'
+bob -"john smith"	Any record containing the word 'bob' but not the phrase 'john smith'
-john +smith	Any record containing the phrase 'smith' but not 'john'
+*ohn +smith	Any record containing a word ending in 'ohn' and also having the word 'smith'
-*ohn +smith	Any record containing the word 'smith' and not containing a word ending in 'ohn'
-joh* +smith	Any record containing the word 'smith and not containing a word starting with 'joh'

Note that this is a boolean search system. The wildcard (*) operator works either at the beginning or end of a word, not in the middle, so rather than searching sm*th one would search for +sm* +*th.

Note that for clarity it is recommended to use spaces between search terms. While -john+smith may work, more advanced queries will not parse correctly if using e.g. -john+*mith instead of -john +*mith