.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Limiting Nickname / Phonetic matching to just First Name

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
The Nickname / Phonetic matching in SharePoint 2010 is a nice new feature, where searching for Jeff will pull up results for Geoff, Jeffrey, etc. However, it also searches surnames and pulls in people with a last name like Jefferson, Jeffery, Jeffrey When creating your query, is there any way to limit the nickname searching to just the forename? If I do a queries like "FirstName:Jeff" or "FirstName=Jeff", then it stops doing nickname/phonetic matching. I've also tried "Nickname:Jeff" and "FirstNamePhonetic:Jeff", but these do not pull up any results at all. How does the nickname/phonetic matching work internally, does it search over a number of internal field names (if so, can these be searched using the advanced property search such as FirstName:Jeff). I thought perhaps I could get the kind of search we need by combining it with logical operators, so if I want any person with a first name sounding like Jeff, and surname beginning with B, then I could do this...   LastName:B* (FirstName:Jeff* OR Jeff) ...but the Jeff on it's own without a Property name Prefix causes a Malformed Query error, I assume it cannot be applied with Logical Operators. Changing the query to...   LastName:B* FirstName:Jeff* Jeff ...brings results, but the wrong results we want as the query does not pull back people with a Forename of Geoff, presumably

View Complete Post

More Related Resource Links

Disable Phonetic & Nickname Search in SharePoint 2010 Enterprise search



We are using SharePoint 2010, and we would like to disable / remove phonetic and Nick Name search.


1) Is this really possible to remove?

2) I am trying to remove few NickNames froms the Search Service through Remove-SPEnterpriseSearchLanguageResourcePhrase.(http://technet.microsoft.com/en-us/library/ff607611.aspx) . I want to remove only few Nickname Mappings? Above link does not explain much about Identity parameter.


Is this load full or matching one only... coz of need to know performance



This my Two Table i have one doubt...

For my first table i have select Top 2 from Employee_info 

and second table itz just selct * from MDEp..

What my doubt is on loading the above report?

Is this load all the record from MDep or just matching one based on Employee_info..?

The Polyglot Programmer: Mixing And Matching Languages


See why you need to be a polyglot programmer and what mixing and matching languages can do for your projects.

Ted Neward

MSDN Magazine March 2009

SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier


Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007

No Results matching your search were found. WSS 3.0


I've got one sharepoint 3.0 site, which is a hostNamedSiteCollection which won't return any results when we search it - searching the entire site or a single list both produce the same "no results matching your search were found".
The site uses Windows Authentication.  We have no Alternate Access Mappings set up. It is regular HTTP
I've added test content to other sites housed in the same Web Application and searched - that new data is appearing in the results.
I did a backup using STSADM and restored the site to my dev server (as both a hostNamedSiteCollection & a regular site collection) - searches return results just fine.
I deleted the site from the prod server and restored it (into a different content database even!) from a backup  I made with STSADM - no results are returned.
I restored the site to the same web application as a Standard site (http://webapp/sites/sitename) (NOT a host named site collection) and results ARE returned.

I've looked at the trace logs & application logs on the server, but can't find any errors that I can tell might be related..

This is the only site I've ever seen have this problem.  We have plenty of other hostNamedSiteCollections and search is working fine on them.


Matching set of characters via regular expression

I need to be able to match sets of quote and space characters in a string and replace these accordingly. I currently have this done in 2 lines of code, but would like to use regular expression so that I can use only 1 line of code. See below: var Qt = unescape("%22"); //quote char var Sp = unescape("%20"); //space var Cr = unescape("%0d"); //carriage return var Lf = unescape("%0a"); //line feed var CrLf = Cr + Lf;  //carriage return & line feed stringOut = stringIn.replace(Qt+Qt+Sp+Qt,Qt+Qt+CrLf+Qt); stringOut = stringOut.replace(Qt+Qt+Sp+Qt+Qt,Qt+Qt+CrLf+Qt+Qt);   I want to replace space in string like in pattern below with carriage return line feed: (in hex) 22 22 20 22 or 22 22 20 22 22. This needs to return 22 22 0D 0A 22 or 22 22 0D 0A 22 22   Line in green above will only match and replace 22 22 20 22 , but I want have regular expression into 1 line of code which  will match and replace either 22 22 20 22 or 22 22 20 22 22  

SELECT statement to return NULL by matching data from another table.

Hi,I am fairly new at SQL and I have been struggling for days now trying to find an answer to my problem and i have come to the point where i have run out of ideas and about to give up. I'm hoping someone can put me in the correct path. The problem I have 3 table Table 1 Department" has the following columns: REF, NAME Table 2  "Department_Collection" has the following columns: REF, DEPARTMENT_REF, MANAGER_REF, STORE_REF, ACTIVE Table 3 Store" has the following columns: REF, NAME, STORE_ID  What i am trying to do is to take all the rows in the Department table and get a matching row (DEPARTMENT.NAME, DEPARTMENT_COLLECTION.REF) from the Department_Collection table, if it does not match any then still display DEPARTMENT.NAME but mark DEPARTMENT_COLLECTION.REF as null. I have tried the following select statement but it seem to remove all null values when supplied with a 'storename' SELECT DEPARTMENT.NAME, DEPARTMENT_COLLECTION.REF FROM DEPARTMENT_COLLECTION right outer join DEPARTMENT on DEPARTMENT_COLLECTION.DEPARTMENT_REF = DEPARTMENT.REF left outer join STORE on DEPARTMENT_COLLECTION.STORE_REF = STORE.REF where STORE.NAME = 'storename' order by DEPARTMENT.NAME   Any help will be greatly appreciated. Thanks

Limiting MySites and Email during closed POC.

SharePoint 2010, Small Farm Installation. Win2008R2, SQL2008R2  Howdy, I'm wrapping up a Proof of Concept and about to deploy it to users.  Management has asked that I limit the visiting of the Mysites to only the core POC folks.  About 40 or so people, likely a slowly expanding circle. Once the POC is completed, I envision it opening up to the entire company, and creating an extranet, and a second farm for clients.  This POC will enclude Enterprise Search, Productivity Hub, and numerous collaborative type sites.  What is the best way to effectively remove rights to all but the minimal group from accessing the Mysites.  If I pull the profiles from AD for the entire company does this somehow provide rights to this area? Also, is there a way to block emails from being sent to staff, with the exception of the POC group..  I hope I'm explaining this with enough detail.  Thanks,  

Inline Editing No Matching Records - No Insert

Hello.  I have been using Inline editing in Sharepoint Designer 2010.  Is it possible to have the insert link displayed even when there are no matching records?  The Default view shows edit, delete, and insert links.  But, the No-Matching Records template doesn't.  I think I can use Newform.aspx for the first record instead, but would like it to operate the same way for inserts as it does when there are records.  Thanks

Wild Card Best Bet Matching

Is there a way to use wildcards in the keywords used in the Best Bets configuration?

Percentage of matching days off among employee's

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday). I want result in percentage.result like thisConsistency Days of assignment            Across 4 weeks            3 weeks                2weeks                0                                                             2%                                   0%     &

Creating and sharing new sharepoint site to internet, limiting user access

I am a new hire into an existing business as I.T. I know the networking, I know the computers. The owner now wants me to learn Sharepoint among some other things. They currently use WSS 3.0. I have been reading up on this for the last month. I think I am ready to extend the current site to make it an Internet site so the employees can login. Some other things we would like to do I have read up on and it looks like they can be done, things such as inventory tracking in collaboration with QuickBooks and creating a website / portal for clients to have a unique login on and can see the status of their jobs in custom SharePoint lists. As far as I can tell the clients need an AD account. However, apart from that I am not sure what to do. A little background.  The company has multiple clients, and we ship things out daily to those clients.  We use Sharepoint to track the status of the jobs as they progress through the stages ultimately going to delivery. There is one common page that lists all the jobs by all clients that is updated constantly. We would like to allow multiple (different) clients/logins and have a page customized for each client.  For example, you are a client and go to www.companyname.com/sharepointsite.html.  From there you would get to a portal page with a login. Once logged in you will be presented with the Shar

Limiting records returned by AutoCompleteExtender

Hi all,   I am using AutoCompleteExtender on a text box as follows <cc1:AutoCompleteExtender ID="aacId" runat="server" DelimiterCharacters="" Enabled="True"                        CompletionListCssClass="autocompleteplus_listItem" CompletionListHighlightedItemCssClass="autocompleteplus_highlightedListItem"                        CompletionListItemCssClass="autocompleteplus_listItem" CompletionListElementID="autocompleteplus_completionListElement"                        ServiceMethod="GetCompletionListId" ServicePath=""                         TargetControlID="txtCandidateId" MinimumPrefixLength="2"                         CompletionSetCount="10"> My problem i

Limiting Search Scopes to Articles, .docs, .xls, etc.

We have a customized site with a number of workarounds, which has necessitated using multiple pages to display data. EG, a contributor might use an "AnnouncementUPLOAD.aspx" page to add data displayed through a Web Part on "Announcement.aspx". I know I can Security Trim at the page and DocLib levels which would carry over into what's revealed by Search, but I'm curious if I can handle this through Scopes. So, if I ran a search for "George Washington", I'd want to return: items in DocLibs (ie Office Documents) items from Announcements, but NOT the full Announcement List. (ie not the http://.../pages/Announcement.aspx page, but the http://.../lists/Announcement.aspx page.) Doable? Thanks!

Call specific web service method by matching string value to method name?

I am getting a value in string format.  Then, I call a web service and try to dynamically call the method that corresponds to the string's value.  It doesn't work.  Any ideas?              Dim methodname As String = "getquotes"                 Dim track As localhost.Tracker = New localhost.Tracker()                 'the below line is where it fails                 track.methodname(parameter)               

LIKE Condition - Single Percentage Sign Matching?


What is the expected behavior when a LIKE condition specifies a single percentage sign? For example, if I have a Customer table with a CustomerName field and I write the following SQL Query:

SELECT * FROM Customer WHERE CustomerName LIKE '%'

  1. Does the single percentage sign negate the LIKE condition?
  2. Would this specific statement be equal to just SELECT * FROM Customer?
  3. Finally, does this work with all data types, or just char/nchar/varchar/nvarchar?



I have two tables, and i want to return all records where both fields match for example below is a sample table

name Disp settext
A and E Bank Issue
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend