Solr Query Language Cheat Sheet
This cheat sheet is a quick reference to the Solr query language. Use this syntax when querying Fusion via the Query API.
Additional information about Solr query syntax can be found in the Solr Query documentation.
There are two ways to query a Fusion collection using the parameters below:
-
Enter query parameters in the Query Workbench or the Quickstart.
-
Append query parameters to the
/query/{id}
endpoint.
Wildcards
Wildcards and regular expressions are supported.
-
?
Single-character wildcard
-
*
Multi-character wildcard
Escape characters
Some characters in query fields must be escaped using a backslash \
. Adding \
before the following includes them in the query as literal values:
-
?
-
*
-
\
-
/
-
"
Queries against facets are case sensitive. |
Common query parameters
|
Defines a query using standard query syntax. This parameter is mandatory. |
|
Filter query. A query string that limits the query results without influencing their scores. |
|
Sort field/direction.
The field on which to sort, followed by a space and direction ( |
|
Max results per page. This sets the "page size" for paginated search results. |
|
Pagination offset. The number of results to skip, for pagination purposes. |
|
Field List. The list of fields to return in the query results. |
|
Default field. Used to configure the |
|
Response writer. Select the response format by specifying one of Solr’s response writers. |
Query examples
-
Search only the
title
field in the "docs" collection for the term "solr", and format the results as JSON:
http://FUSION_HOST:FUSION_PORT/api/query-pipelines/default/collections/docs/select?q=solr&fl=title&wt=json
-
Use the following query with wildcards and character escaping in the Query Workbench to search for both
BLU RAY MOVIES
andCAMERA
classes in theVIDEO/CD
andPHOTO/CAMERA
departments:-
class_s:*RA* AND department_s:*O\/C*
-
-
Use a movie collection to select the movie ID and rating where the rating is equal to 4.
http://FUSION_HOST:FUSION_PORT/api/query-pipelines/default/collections/docs/select?q=*:*&fl=movie_id,rating&fq=rating:4
-
Search for movies with "black" in the title, starting at the 20th result for pagination, then return the results as XML:
http://FUSION_HOST:FUSION_PORT/api/query-pipelines/default/collections/docs/select?q=black&fl=title&start=20&rows=20&wt=xml