Retrieving content using KQL queries

KQL consists of free text keywords including words, phrases, and property restrictions. KQL queries are case-insensitive, but the operators are not and have to be specified in uppercase. A free text expression in a KQL query can be a word without any spaces or punctuation or a phrase enclosed in double quotation marks.

The following examples will return the content that have the words Merger and Acquisition:

merger acquisition
merge* acquisition
acquistion merg*

It is important to note that KQL queries do not support suffix matching. This means you cannot use a wildcard (*) operator before a word or phrase in a KQL query.

We can use Property restrictions in a KQL query in the following format. There should not be any space between the Property name, the Property operator, and the Property value:

<Property Name><Property Operator><Property Value>

For example, author "John Doe" will return content whose author is John Doe;

filetype:xlsx will...