WHERE Filters

When link paths are used in the fields parameter, values can be filtered using a WHERE expression. For example, consider this URI query:

.../_query?q=Size>1000&f=InternalRecipients.WHERE(Person.Department:support)

This returns only InternalRecipients whose Person.Department contains the term “support”.

The WHERE clause does not have to be applied to the terminal field in the link path. For example:

.../_query?q=Size>1000&f=InternalRecipients.Person.WHERE(Department:support).Office

This returns InternalRecipients.Person.Office values for each message but only for InternalRecipients.Person objects whose Department contains the term “support”.