搜寻外部SQL数据库-没有数字的搜索结果 [英] Crawling External SQL Database - No search results for Numbers

问题描述

你好

我只是设法在SharePoint 2016搜索中爬网外部SQL数据库，但是在获取搜索结果时遇到了问题.

Hi there

I just managed to crawl an external SQL Database in SharePoint 2016 Search, but I am having problems to get the search results I am looking for.

为简化方案，假设在SQL表中有两个列:Project_Number和Project_Name.

如果我搜索Project_Name，一切都很好.显示结果，包括Project_Number.
如果我搜索Project_Number，则不会显示任何结果.

而且我不明白为什么.

由于我是该搜索主题的新手，因此我尚未创建任何托管属性，抓取属性，结果类型或模板模板.因此，一切都应该是开箱即用的.

有提示吗?

To simplify the scenario, assume that in the SQL table there are two colums: Project_Number and Project_Name.

If I search for the Project_Name everything is fine. Results are shown, including the Project_Number.
If I search for the Project_Number no results are shown. 

And I don't understand why.

As I am quite new to this search topic, I have not created any managed properties, crawl properties, result types nor template costumizations. So everthing should be pretty much as out of the box.

Any hints?

推荐答案

Hi Christian，

Hi Christian,

我目前正在SharePoint 2016中进行测试，并将尽快进行更新.

I am currently doing test in my SharePoint 2016 and will give an update as soon as possible.

此外，请参考以下有关如何设置SharePoint搜索以使用BCS抓取外部内容的文章

Besides, refer to the following article about how to Setup SharePoint Search to Crawl External Content With BCS

http://prairiedeveloper.com/2016/04/setup-sharepoint-search- crawl-bcs/

最好的问候

Lisa Chen

Lisa Chen

这篇关于搜寻外部SQL数据库-没有数字的搜索结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！