question

FrancescoBorraccino-4609 avatar image
0 Votes"
FrancescoBorraccino-4609 asked YiLu-MSFT answered

Why does using alias in KQL does no give me results?

I have a currency column with the internal name Importo.

On the managed properties page I edited the property RefinableDecimal00 with alias Importo and mapping ows_Importo.

When I try to search using the alias as below:

Importo:49.59

I get zero results

Instead when I try to search using RefinableDecimal00 as below:

RefinableDecimal00:49.59

I get the results correctly

How can I get the results using the alias?

I have this problem only on some site collections and also on the Number columns

office-sharepoint-online
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FrancescoBorraccino-4609
Does this issue happen in list search box or search box in homepage?

0 Votes 0 ·

Hi @YiLu-MSFT
this issue happen in list search box and by code using Microsoft.SharePoint.Client.Search.Query.KeywordQuery, search box in homepage works fine

0 Votes 0 ·

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @FrancescoBorraccino-4609
I have reproduced your issue on my server, it seems that this issue is by design and I could not find any article to explain it.

We suggest you make your features suggestions on the Microsoft SharePoint Dev Platform feedback portal on UserVoice.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.