This cheat sheet is a quick reference to the Solr query language. Use this syntax when querying Fusion via the Query API There are two ways to query a Fusion collection using the parameters below: Wildcards and regular expressions are supported.

​
Wildcards

  • ? Single-character wildcard
  • * Multi-character wildcard

​
Common query parameters

qThe full Solr query, using Lucene query syntax.
fqFilter query. A query string that limits the query results without influencing their scores.
sortSort field/direction. The field on which to sort, followed by a space and direction (desc or asc). You can specify multiple sort fields like this: sort=title asc,year desc.
rowsMax results per page]. This sets the “page size” for paginated search results.
startPagination offset. The number of results to skip, for pagination purposes.
flField List. The list of fields to return in the query results.
wtResponse writer. Select the response format by specifying one of Solr’s response writers.
See also the Solr facet parameters documentation.

​
Query examples

  1. 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
  1. Use the following query with wildcards and character escaping in the Query Workbench to search for both BLU RAY MOVIES and CAMERA classes in the VIDEO/CD and PHOTO/CAMERA departments:
    • class_s:*RA* AND department_s:*O\/C*
  2. 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
  1. 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