I want to build a KQL query for some server side code to search both custom properties and document content. So if for example there was a property called reference and we are looking for content say "affiliated" I have tried something like:
Reference: "1234" and affiliated
But the query returns items with the terms Reference and affiliated in it. It looks like the reference property is being applied as well so I am just getting a subset of my results.
Any ideas would be greatly appreciated.