Azure如何搜索包含引号的文本(转义单引号)? [英] How to do Azure search for text containing quotes(escape single quote)?

问题描述

我有如下查询的天蓝色搜索

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如何搜索包含引号的文本(转义单引号)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！