Keyword Query Language (KQL) Cheat Sheet

Read more on Keyword Query Language (KQL) or check out The SharePoint Agency cheat sheet below...

​

Typing more than one term is equivalent to adding AND between your terms.

​will return the same results as...


​

Adding a wildcard (*) will return everything!​

Adding a wildcard (*) after a word will enable prefix matching.

is the same as


​

Use property restrictions

Beware as author: "Hayden Sinclair" (with a space)
is the same as
author: AND "Hayden Sinclair"

Apply multiple property restrictions in the same search.

filetype:docx filetype:pdf
filename:"client terms and conditions" filename:"New Business Card Design"

Using the same property is equivalent to adding an OR between your terms.


author:"Hayden Sinclair" OR author:"Jim Khan"
filetype:docx OR filetype:pdf
filename:"client terms and conditions" OR filename:"New Business Card Design"

NOT will remove results with your offending term.

​

NEAR will show words in close proximity.

You can also specify how close
Christchurch NEAR(n=10) Earthquake
Christchurch NEAR(n=50) Earthquake​

​

WORDS will rank both or your terms together rather than separately.

is the similar to


But items with both Chch and Christchurch will count together and will rank higher

Quotation Marks will turn your search into a Phrase.

versus 

​will return the same results as...
 

Time Specific Queries.

 

Taxonomy Search.