I am working on SharePoint server 2013 enterprise edition site collection. And I am facing some problems in understanding how do SharePoint create the following names for the site columns:-
- Site column internal names at the list level.
- Crawl properties names
- Managed properties names
I got this scenario inside my Site collection:-
I have 2 site columns with these INTERNAL names "
Software_x0020_Development_x0020_Risk_x002F_Issue_x0020_Owner
" & "Software_x0020_Development_x0020_Owner
" .On the list level these 2 site columns go the same internal names. when I access the site columns inside the list content type i noted that they got the same internal name which is "
Software_x0020_Development_x0020
" , but still they have different column id.Also these 2 site columns got a single crawl property which is "
ows_q_USER_SoftwareDevelopment
" and a single managed property which is "SoftwareDevelopmentOWSUSERUser
" inside the search service.
So can anyone advice on the below, 3 questions please:-
Why SharePoint create the same column names at the list level, is there any truncate that will be done automatically for the site columns internal names at the list level? and also Why it creates a single managed property and a single crawl property for these 2 different site columns "
Software_x0020_Development_x0020_Risk_x002F_Issue_x0020_Owner
" & "Software_x0020_Development_x0020_Owner
" ???The above have created a problem inside my content search web part, because when i wrote the following query inside my Content Search web part "
SoftwareDevelopmentOWSUSERUser:{User.Name}
" , I got results from the two site columns since they have the same managed property and also the same crawl property. so how did SharePoint recognize that the managed property which is map to the same crawl property is referring two site columns that have different internal names?Now how is SP recognizing the relation between the single crawled property and its 2 site columns? as the crawl property name ("
ows_q_USER_SoftwareDevelopment
") is just a subset of the complete site columns internal names ("Software_x0020_Development_x0020_Risk_x002F_Issue_x0020_Owner
" & "Software_x0020_Development_x0020_Owner
" .). . weird is it ?
Thanks in advance for any help
HINT.. Now my understanding for the above is that i got this conflict because my site columns internal names are some how long,, and when sharepoint builds the crawl/managed properties it will not only remove white spaces but also will apply some character truncating ,, and since my 2 site columns have the exact characters at the beginning so this result in a single crawl/managed property representing 2 different site columns !! could this be the case??