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

Question

question

FrancescoBorraccino-4609 asked Apr 20, '22 YiLu-MSFT answered Apr 22, '22

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

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

YiLu-MSFT · Apr 21 at 02:33 AM

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

0 ·

FrancescoBorraccino-4609 YiLu-MSFT · Apr 22 at 08:44 AM

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 ·

Answer 1 · 2022-04-22T08:58:51.15Z

YiLu-MSFT answered Apr 22, '22

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

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

question