本文介绍了Azure如何搜索包含引号的文本(转义单引号)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有如下查询的天蓝色搜索
I have a Query for azure search as given below
results = indexClient.Documents.Search<Hotel>("", new SearchParameters { IncludeTotalResultCount = true, Filter = "(Provider eq 'Auction.com' or Provider eq 'Zeroiron' or Provider eq 'Gilbert'sYard')" });
当前查询给出错误,因为正如我给每个提供者加引号一样,但是吉尔伯特的院子已经在提供者名称中包含了一个引号,因此要搜索带有吉尔伯特的码"的相同查询,我必须在查询吗?
the current Query Gives error because as i have given every provider inside quotes , but Gilbert's Yard already have a Quote inside the provider name itself, so to search for same Query with "Gilbert's yard" what change i have to make in the Query?
上面的查询是这样生成的,
The above Query is generated like this,
var selectedProviders = this.Providers.Where(i => i.IsSearchable).ToList();
if (selectedProviders.Count > 0)
{
if (filterString.Length > 0)
filterString.Append(" and ");
filterString.Append("(");
var count = 1;
foreach (var provider in selectedProviders)
{
filterString.Append(($"Provider eq '{provider.ProviderName}'"));
if (count < selectedProviders.Count)
{
filterString.Append(" or ");
}
count++;
};
filterString.Append(")");
}
在这里我应该如何更改我的代码?
And how i should change my Code here?
推荐答案
要实现这一点,我们需要将单引号替换为两个单引号.
To achieve this we need to replace single quote with two single quotes.
filterString.Append(($"Provider eq '{provider.ProviderName.replace("'","''")}'"));
这将为我解决问题.
这篇关于Azure如何搜索包含引号的文本(转义单引号)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!