Version 3 end of life
This version of Silverstripe CMS will not recieve any additional bug fixes or documentation updates. Go to documentation for the most recent stable version.

SearchFilter Modifiers

The filter and exclude operations specify exact matches by default. However, there are a number of suffixes that you can put on field names to change this behavior. These are represented as SearchFilter subclasses and include.

An example of a SearchFilter in use:

	// fetch any player that starts with a S
	$players = Player::get()->filter(array(
		'FirstName:StartsWith' => 'S',
		'PlayerNumber:GreaterThan' => '10'

	// to fetch any player that's name contains the letter 'z'
	$players = Player::get()->filterAny(array(
		'FirstName:PartialMatch' => 'z',
		'LastName:PartialMatch' => 'z'

These suffixes can also take modifiers themselves. The modifiers currently supported are ":not", ":nocase" and ":case". These negate the filter, make it case-insensitive and make it case-sensitive, respectively. The default comparison uses the database's default. For MySQL and MSSQL, this is case-insensitive. For PostgreSQL, this is case-sensitive.

The following is a query which will return everyone whose first name starts with "S", either lowercase or uppercase:

	$players = Player::get()->filter(array(
		'FirstName:StartsWith:nocase' => 'S'

	// use :not to perform a converse operation to filter anything but a 'W'
	$players = Player::get()->filter(array(
		'FirstName:StartsWith:not' => 'W'