Query and Sorting Options

When you call the search() method using a query string alone, the results are returned according to the default query options:

Documents are returned sorted in order of descending rank
Documents are returned in groups of 20 at a time
Retrieved documents contain all of their original fields

You can use an instance of the Query class as the argument to search() to change these options. The Query class allows you to specify how many documents to return at a time. It also lets you customize the contents of the retrieved documents. You can ask for document identifiers only, or request that documents contain only a subset of their fields. You can also create custom fields in the retrieved documents: snippets (fragments of text fields showing the text surrounding a matched string), and field expressions (fields with values derived from other fields in the document).

Apart from the query options, the Query class can also include an instance of the SortOptions class. Using sort options you can change the sort order, and sort the results on multiple keys.

Searching with the Query class

When you search with an instance of the Query class, you need to construct an instance of the class in several steps. This is the general order:

Create a query string.
Create SortOptions if needed.
Create QueryOptions .
Create a Query object that includes the query string and the (optional) QueryOptions .
Call the search method on the Query object.

The various query and sort options are specified by calling setter methods on instances of the QueryOptions.Builder and SortOptions.Builder classes, as in this example:

import com.google.appengine.api.search.Index;
import com.google.appengine.api.search.IndexSpec;
import com.google.appengine.api.search.SearchServiceFactory;
import com.google.appengine.api.search.Query;
import com.google.appengine.api.search.QueryOptions;
import com.google.appengine.api.search.Results;
import com.google.appengine.api.search.SearchException;
import com.google.appengine.api.search.SortExpression;
import com.google.appengine.api.search.SortOptions;
import com.google.appengine.api.search.ScoredDocument;

try {
    // Build the SortOptions with 2 sort keys
    SortOptions sortOptions = SortOptions.newBuilder()
        .addSortExpression(SortExpression.newBuilder()
            .setExpression("price")
            .setDirection(SortExpression.SortDirection.DESCENDING)
            .setDefaultValueNumeric(0))
        .addSortExpression(SortExpression.newBuilder()
            .setExpression("brand")
            .setDirection(SortExpression.SortDirection.DESCENDING)
            .setDefaultValue(""))
        .setLimit(1000)
        .build();

    // Build the QueryOptions
    QueryOptions options = QueryOptions.newBuilder()
        .setLimit(25)
        .setFieldsToReturn("model", "price", "description")
        .setSortOptions(sortOptions)
        .build();

    // A query string
    String queryString = "product: piano AND price < 5000";

    //  Build the Query and run the search
    Query query = Query.newBuilder().setOptions(options).build(queryString);
    IndexSpec indexSpec = IndexSpec.newBuilder().setName(indexName).build();
    Index index = SearchServiceFactory.getSearchService().getIndex(indexSpec);
    Results<ScoredDocument> result =  index.search(query);
} catch (SearchException e) {
    // handle exception...
}

QueryOptions

You must use the QueryOptions.Builder to set query options. You do not have access to these properties directly.

These properties control how many results are returned and in what order. The offset and cursor options, which are mutually exclusive, support pagination. They specify which selected documents to return in the results.

Property	Description	Default	Maximum
`Limit`	The maximum number of documents to return in the results.	20	1000
`NumberFoundAccuracy`	This property determines the accuracy of the result returned by `Results.getNumberFound()` . It sets a limit for how many matches are actually counted, stopping the search when the limit is reached. If the number of matches in the index is less than or equal to the limit, the count returned is exact. Otherwise, the count is an estimate based on the matches that were found and the size and structure of the index. Note that setting a high value for this property can affect the complexity of the search operation and may cause timeouts.	100	10000
`Offset`	The offset of the first document in the results to return.	0. Results will contain all matching documents (up to limit).	1,000
`Cursor`	A cursor can be used in lieu of an offset to retrieve groups of documents in sorted order. A cursor is updated as it is passed into and out of consecutive queries, allowing each new search to be continued from the end of the previous one. Cursor and offset are discussed on the Handling Results page.	Null. Results will contain all matching documents (up to limit).	-
`SortOptions`	Set a `SortOptions` object to control the ordering of the search results. An instance of `SortOptions` has its own set of properties which are described below.	Null. Sort by decreasing document rank.	-

These properties control what document fields appear in the results.

Property	Description	Default
`ReturningIdsOnly`	Set to `True` or `False` . When `True` , the documents returned in the results will contain IDs only, no fields.	`False` (return all fields).
`FieldsToReturn`	Specifies which document fields to include in the results. No more than 100 fields can be specified.	Return all document fields (up to 100 fields).
`ExpressionsToReturn`	Field Expressions describing computed fields that are added to each document returned in the search results. These fields are added to the expressions property of the document. The field value is specified by writing an expression which may include one or more document fields.	None
`FieldsToSnippet`	A list of text field names. A snippet is generated for each field. This is a computed field that is added to the expressions property of the documents in the search results. The snippet field has the same name as its source field. This option implicitly uses the snippet function with only two arguments, creating a snippet with at most one matching string, based on the same query string that the search used to retrieve the results: `snippet("query-string", field-name)` . You can also create customized snippets with the `ExpressionsToReturn` option by adding a Field Expressions that explicitly calls the snippet function .	None

SortOptions

The properties of SortOptions control the ordering and scoring of the search results. You must use the SortOptions.Builder to set the sort options. You do not have access to these properties directly.

The properties of SortOptions control the ordering and scoring of the search results.

Property	Description	Default
`SortExpressions`	A list of `SortExpressions` representing a multi-dimensional sort of Documents.	None
`MatchScorer`	An optional `MatchScorer` object. When present this will cause the documents to be scored according to search term frequency. The score will be available as the `_score` field. Scoring documents can be expensive (in both billable operations and execution time) and can slow down your searches. Use scoring sparingly.	None
`Limit`	Maximum number of objects to score and/or sort. Cannot be more than 10,000.	1,000

Sorting on multiple keys

You can order the search results on multiple sort keys. Each key can be a simple field name, or a value that is computed from several fields. Note that the term 'expression' is used with multiple meanings when speaking about sort options: The SortOption itself has an expressions attribute . This attribute is a list of SortExpression objects which correspond to sort keys. Finally, each SortExpression object contains an expression attribute which specifies how to calculate the value of the sort key. This expression is constructed according to the rules in the next section.

A SortExpression also defines the direction of the sort and a default key value to use if the expression cannot be calculated for a document. Here is the complete list of properties:

Property	Description	Default
`Expression`	An expression to be evaluated when sorting results for each matching document.	None
`Direction`	The direction to sort the search results, either `ASCENDING` or `DESCENDING` .	`DESCENDING`
`DefaultValue` `DefaultValueDate` `DefaultValueNumber`	The default value of the expression, if no field is present and cannot be calculated for a document. A text value must be specified for text sorts. A numeric value must be specified for numeric sorts.	None

To sort or not to sort

If you do not specify any sort options, your search results are automatically returned sorted by descending rank. There is no limit to the number of documents that are returned in this case. If you specify any sorting options, the sort is performed after all the matching documents have been selected. There is an explicit property, SortOptions.limit , that controls the size of the sort. You can never sort more than 10,000 docs, the default is 1,000. If there are more matching documents than the number specified by SortOptions.limit , search only retrieves, sorts, and returns that limited number. It selects the documents to sort from the list of all matching documents, which is in descending rank order. It is possible that a query may select more matching documents than you can sort. If you are using sort options and it is important to retrieve every matching document, you should try to insure that your query will return no more documents than you can sort.

Writing expressions

Expressions are used to define Field Expressions (which are set in the QueryOptions ) and Sort Expressions (which are set in the SortOptions ). They are written as strings:

"price * quantity"
"(men + women)/2"
"min(daily_use, 10) * rate"
"snippet('rose', flower, 120)"

Expressions involving Number fields can use the arithmetical operators (+, -, *, /) and the built-in numeric functions listed below. Expressions involving geopoint fields can use the geopoint and distance functions. Expressions for Text and HTML fields can use the snippet function.

In addition to document field names, numeric expressions can also include the built-in field names _rank , the document rank, and _score . Note that _score is only available if a MatchScorer was specified with the SortOptions .

Numeric functions

The expressions to define numeric values for FieldExpressions and SortExpressions can use these built-in functions. The arguments must be numbers, field names, or expressions using numbers and field names.

Function	Description	Example
`max`	Returns the largest of its arguments.	`max(recommended_retail_price, discount_price, wholesale_price)`
`min`	Returns the smallest of its arguments.	`min(height, width, length)`
`pow`	Takes two numeric arguments. The call pow(x, y) computes the value of x raised to the y power.	`pow(x, 2)`
`count`	Takes a field name as its argument. Returns the number of fields in the document with that name. Remember that a document can contain multiple fields of different types with the same name. Note: `count` can only be used in `FieldExpressions` . It cannot appear in `SortExpressions` .	`count(user)`

Geopoint functions

These functions can be used for expressions involving geopoint fields.

Function	Description	Example
`geopoint`	Defines a geopoint given a latitude and longitude.	`geopoint(-31.3, 151.4)`
`distance`	Computes the distance in meters between two geopoints. Note that either of the two arguments can be the name of a geopoint field or an invocation of the geopoint function. However, only one argument can be a field name.	`distance(geopoint(23, 134), store_location)`

Snippets

A snippet is a fragment of a text field that matches a query string and includes the surrounding text. Snippets are created by calling the snippet function:

snippet(query, body, [max_chars])

`query`

A quoted query string specifying the text to find in the field.

`body`

A field name.

`max_chars`

The maximum number of characters to return in the snippet. Defaults to 160 characters.

The function returns an HTML string. The string contains a snippet of the body field's value, with the text that matched the query in boldface.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License , and code samples are licensed under the Apache 2.0 License . For details, see our Site Policies .

Last updated July 14, 2014.

Java