Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Special Announcement: SQL Server Performance Tuning Tips and Tricks Webinar
 

Searching by Using Enterprise Keywords in SharePoint 2010


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

One of the most general requirements we come across is to make enterprise search more compact and effective, providing quick and more accurate results. One of the major problems is to provide the right filters to find a particular record. For instance in a large enterprise environment, searching for a person called Jeffry from the Finance department, is not always a feasible option. Filters may not provide the accurate results for what users are expecting.

Solution

To search for particular data as above mentioned, SharePoint provides new feature called "Enterprise Metadata and Keywords". Fundamentally, it allows one to relate a keyword with a particular set of data like list records. When the keyword is searched, the (out of the box) SharePoint search results web part provides the only records who are related to mentioned keyword. To demonstrate this, we have created several similar list items with the same data. Our purpose is to show how normal searching provides results. And after defining the keyword how much more effective the results would be to enterprise users.

We have defined a couple of sample employee list items which contains basic information like Employee name, address, Phone and others.

name

Now we will use the default search that SharePoint provides. If required, one can even use the SharePoint Search Center as one can get all the web parts preconfigured with the search box. Now we search for a record named "Jeffry" in search box. We have results from all the lists, records and others, as shown below:

articles

The results what we got were not the desired ones.

Now here comes the new feature called "Enterprise Metadata and Keywords". For activating this feature go to List > List Settings > Permissions and Management > Enterprise Metadata and Keywords Settings

list information

Select the option that will enable you to add keywords to the records and click OK. Basically it will synchronize a single word with a record which will be helpful for the search engine to search the desired record.

keywords

Now one can click on the context menu of the item to add a keyword. In our case it was Jeffry's record from the finance department. Click on context menu > Edit Item.

edit name

In edit item box, you will see a new field appearing named Enterprise Keywords which will relate to the record. In our case, we kept something called "JeffryFinance".

jeffry

Now when we search with "JeffryFinance", the search core results web part will give only one record which is the one related to keyword "JeffryFinance".

may articles

In this way, we can easily make enterprise search simpler, quicker and more effective.

Next Steps


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Rahul Mehta Rahul Mehta is a Project Architect/Lead working at Tata Consultancy Services focusing on ECM.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools