Skip to main content
Bumped by Community user
edited body
Source Link
Steve B
  • 7.6k
  • 9
  • 54
  • 110

In a list I have a column with these values:

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal `*'*?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

In a list I have a column with these values:

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal `*'?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

In a list I have a column with these values:

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal *?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

Tweeted twitter.com/StackSharePoint/status/869128843478609921

In a list I have a column with these values  :

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal * `*'?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

thanks

In a list I have a column with these values  :

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal * ?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

thanks

In a list I have a column with these values:

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal `*'?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

Source Link
Steve B
  • 7.6k
  • 9
  • 54
  • 110

How to escape special characters in a KQL query?

In a list I have a column with these values :

MyField ------- foo.A foo.B foo.* 

I want to search for these values. I've plumbed all managed properties and crawled content.

  • If I search myfield:"foo.", all results are returned ==> Expected
  • If I search myfield:"foo.A", results with the foo.A are returned.==> Expected
  • If I search myfield:"foo.*", both foo.A and foo.B are returned, but not foo.* ==> not Expected. I need to get only foo.*

How to search for literal * ?

I also tried : myfield:"foo.\*", myfield:"\foo.*", myfield:{"foo.*"}, but none worked.

Documentation does not mention any way to escape special characters.

thanks