如何使ProductId Free Text Searchable？ [英] how can I make ProductId Free Text Searchable?

问题描述

在架构管理器中禁用了ProductId的属性。我希望能够检查"Free Text Searchable"和"Free Text Searchable"。如果我在Starter Site的Search框中键入产品ID，则会出现该产品。看起来Starter Site能够使用AdventureWorks目录执行此操作，因为SKU（产品代码）已选中Free Text Searchable属性，并且此属性直接映射到ProductId。但是，在我创建的目录上，我映射到ProductId的字段称为Style，并且是一个数字数据类型：Free Text Searchable不是此属性的可用复选框。有没有办法在数字属性上进行自由文本搜索？

The properties for ProductId are all disabled in the Schema Manager.  I want to be able to check the "Free Text Searchable" property so if I type the product ID in the Search box on the Starter Site, the product will come up.  It looks like the Starter Site is able to do this with the AdventureWorks catalog because the SKU (Product Code) has the Free Text Searchable property checked and this property is mapped directly to the ProductId.  However, on a catalog that I created, the field I'm mapping to ProductId is called Style and is a Number Data Type:  Free Text Searchable isn't an available checkbox for this property.   Is there any way to do a free text search on a numeric property?

推荐答案

你可以简单地在SQL fullTextCatalog上添加ProductId（我建议每晚重新创建fullText目录的脚本）

you can simply add the ProductId on the SQL fullTextCatalog (I would recommend a script to recreate the fullText catalog everynight)

这篇关于如何使ProductId Free Text Searchable？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！