KQL无法过滤“开头为"的结果

问题描述

我正在尝试在SharePoint Online中的结果查询中筛选值.
例如，我想要所有以"A"开头的值.

初始查询:

属性:A *
-结果为亚当和玛丽"，但还有多余的玛丽和亚当"

我用下划线重新调整了值，但没有解决办法:
属性:A *
结果仍然是"Adam_and_Mary"，但仍然是不需要的"Mary_and_Adam"


我用前导破折号重新调整了值，但没有解决办法:
属性:-A *
结果仍然是"-Adam and Mary"，但仍然是不需要的"-Mary and Adam"

我不明白其中的逻辑.
有什么办法解决这个问题吗?
使用其他查询或重新调整值吗?
Property = A *完全没有结果.

I'm trying to filter values in a results query in SharePoint Online.
I want for example all values starting with an "A".

Initial query:

Property:A*
- Results "Adam and Mary", but also the unwanted "Mary and Adam"

I re-adjusted the values with underscores, but no solution:
Property:A*
Results still "Adam_and_Mary", but still also the unwanted "Mary_and_Adam"


I re-adjusted the values with a leading dash, but no solution:
Property:-A*
Results still "-Adam and Mary", but still also the unwanted "-Mary and Adam"

I don't understand the logic in this.
Is there any way to solve this ?
With another query or re-adjusting the values ?
Property=A* is giving no results at all.

推荐答案

您能不能尝试在前面加上一个'/'

can you please try putting a leading '/'

在您的情况下，它应该是属性:/A *

in your case it should be Property:/A*

https://dev.office.com/sharepoint/docs/general-development/keyword-query-language-kql-syntax-reference

----------------------------------

这篇关于KQL无法过滤“开头为"的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！