Functions for Database Querying

Finder Method

Description

findBy**Description**(...)

 Query based on description

findBy**NameAndDescription**(...)

Query based on name and description

findBy**NameAndDistributorRegion**(...)

Query based on the item’s name and by a related distributor’s region

find**Top10**ByName(...) or find**First10**ByName(...)

Query based on name, but only return the first ten entries

findByName**IgnoreCase**(...)

Query by name, but ignore the case of the text

findByNameAndDescriptionAllIgnoreCase(... )

Query by name and description, but ignoring the case of the text in ALL fields

findByNameOrderByDescriptionAsc(...)

Query by name, but order the results based on the description in ascending order (or use Desc for descending order)

findByReleaseDateAfter(Date date)

Query based on releaseDate being after the date

findByAvailableUnitsGreaterThan(int units)

Query based on availableUnits being greater than units

findByAvailableUnitsGreaterThanEqual(int units)

Query based on availableUnits being greater than or equal to units

findByReleaseDateBefore(Date date)

Query based on releaseDate being before the date

findByAvailableUnitsLessThan(int units)

Query based on availableUnits being less than units

findByAvailableUnitsLessThanEqual(int units)

Query based on availableUnits being less than or equal to units

findByAvailableUnitsBetween(int from, int to)

Query based on availableUnits being between from and to

findByAvailableUnitsIn(Collection unitss)

Query based on availableUnits being found in the supplied collection

findByAvailableUnitsNotIn(Collection units)

Query based on availableUnits NOT being found in the supplied collection

findByNameNotNull() or findByNameIsNotNull()

Query based on name not being null

findByNameNull() or findByNameIsNull()

Query based on name being null

findByNameLike(String f) or findByNameStartingWith(String f) or findByNameEndingWith(String f)

Query based on input being a regular expression

findByNameNotLike(String f) or findByNameIsNotLike(String f)

Query based on input being a regex, with a MongoDB $not applied.

findByNameContaining(String f)

For a string input, query just like Like. For a collection, query testing membership in the collection

findByNameNotContaining(String f)

For a string input, query like NotLike. For a collection, query testing lack of membership in the collection

findByNameRegex(String pattern)

Query using pattern as a regular expression

findByLocationNear(Point p)

Query by geospatial relation using MongoDB’s $near

findByLocationNear(Point p, Distance max)

Query by geospatial relation using MongoDB’s $near and $maxDistance

findByLocationNear(Point p, Distance min, Distance max)

Query by geospatial relation using MongoDB’s $near, $minDistance, and $maxDistance

findByLocationWithin(Circle c)

Query by geospatial relation using MongoDB’s $geoWithin, $circle, and distance.

findByLocationWithin(Box b)

Query by geospatial relation using MongoDB’s $geoWithin, $box, and square coordinates

findByActiveIsTrue()

Query by active being true

findByActiveIsFalse()

Query by active being false

findByLocationExists(boolean e)

Query by location having the same boolean value as the input