MicroStrategy ONE

Search for Data Using Solr Search Syntax

If your dashboard or document contains data from a search source, you can take advantage of Solr's flexible search syntax to analyze your data. For example, you can search for data that contains the terms Business and Analysis in close proximity to each other, or search for data for port numbers that fall within a specific range. You perform a search by typing search queries into the appropriate filter in the Filter panel.

This topic provides a brief introduction to the types of Solr search syntax that you can use to examine your data. For a detailed overview, including information about creating searchers that take advantage of functions, nested queries, boost factors, and more, see the official documentation for the query parser syntax. In most cases, Solr uses the standard Lucene query syntax to perform searches. For a list of exceptions, see the Solr wiki.

You are viewing a dashboard or document that contains data imported from search as a source. The dashboard or document designer has added filters to the dashboard or document that are based on the search data.

If you are viewing a document, the document must be displayed in presentation mode.

Searching for Keywords and Search Phrases

The following are examples of searches for a specific keyword or search phrase.

Task Example Syntax

Search for a keyword in a specific field

Search for the keyword AccessLog in the title field

title:AccessLog

Search for a phrase in a specific field

Search for the phrase Code 1918 in the title field

title:"Code 1918"

Search for a phrase in one field and a second phrase in another field

Search for Error 401 in the title field and Authorization is denied in the body field

title:"Error 401" AND body:"Authorization is denied"

Combine searches for multiple phrases or keywords using operators such as AND or OR

Search for Error 401 in the title field AND Authorization is denied in the body field, or search for Password in the title field.

 

(title:"Error 401" AND body:"Authorization is denied") OR title:Password

Search for a keyword in a specific field, excluding search results with another keyword in the same field

Search for 401 but not 404 in the title field

title:401 -title:404

Search for data in which a field does not contain a specific value

Search for data where the inStock field is not false

-inStock:false

Search for values in a specified range

Search for values from 20020101 to 20030101 in the mod_date field

mod_date:[20020101 TO 20030101]

Searching Using Wildcards

You can use the wildcard character (*) to search for results that are not exact matches. Solr search syntax does not support using a wildcard symbol as the first character of a search.

Task Example Syntax

Search for words starting with a string of characters

Search for any word that starts with En in the title field

title:En*

Search for words starting and ending with specific strings of characters

Search for any word that starts with En and ends with ed in the title field

title:En*ed

Search for values in a field that are less than or equal to a specified numeric value

Search for values in the code field that are less than or equal to 100

code:[* TO 100]

Search for values in a field that are greater than or equal to a specified numeric value

Search for values in the code field that are greater than or equal to 100

code:[100 TO *]

Search for data that contains a specific field

Find data that includes the message field

message:[* TO *]

Search for data that does not contain a specific field

Find data that does not have a message field

-message:[* TO *]

Searching Using Additional Search Options

You can search for terms that are a given number of words away from each other (called a proximity search).

Task Example Syntax

Search for keywords that are a specific number of words away from each other

Search for log analysis within 4 words from each other

"log analysis"~4

Search for transposed words

Search for log analysis or analysis log

"log analysis"~1

You can approximate a search for multiple keywords (for example, a search for business AND analysis) using a search with a large proximity value, such as "business analysis"~10000000. For practical purposes, this returns the same group of results as searching for business AND analysis. Unlike a search for business AND analysis, however, results in which business and analysis are closer together are regarded as having a higher search relevance. However, the proximity search also requires more time and system resources to perform.

You can determine which parts of a search query are treated as more important by providing a numeric boost factor. For example, the following query assigns higher importance to matches in the title field than matches in the body field: (title:MicroStrategy OR title:Analytics)^1.5 (body:Intelligence OR body:Server).

For a detailed overview of Solr query syntax, including information about creating queries that take advantage of functions, nested queries, boost factors, and more, see the official documentation for the query parser syntax. In most cases, Solr uses the standard Lucene query syntax to perform searches. For a list of exceptions, see the Solr wiki.

Related Topics

Import Data from Search Engine Indices

How to Create a Data Source Connection to a Search Source