1

I am working on a sharepoint server 2013, now i create a new Web Part of type Search Content Web Part. where inside the query builder i got a drop-down menu to select a property name as follow:-

enter image description here

now i always have some difficulties in understanding the following:-

1- how i can see the map between the actual site columns and the property name inside the above property drop down list?

2- from my own test i can see that a single property name can reference multiple site columns even when these site columns exists inside different site collections. for example i have three site collections, and inside each site collection i have a site column name "Item Number". now when i select a property named "ItemNumberOWSTEXT " , and define the following criteria (ItemNumberOWSTEXT:-T-) :-

enter image description here

i got items from different site collections which have their item number fields containing "-T-", so in other word the ItemNumberOWSTEXT property is actually refereeing multiple site columns from multiple site collections? so is this possible and how i can check these?

EDIT

not sure how things can go crazy easily in sharepoint .. now i went to "Central administration" >> "Managed Services" >> "Search Service" >> "crawl properties"and i search for the word number, i got these results:-

enter image description here

now i can not understand the following 2 points:-

1- as i mentioned before i have three site columns inside three site collections which have their internal names as follow:-

- ItemNumber
- ItemNumber
- Item_X0020_Number

but inside the crawl properties i got 2 crawl properties named ows_itemNumber & ows_item_x0020_number ,, so there is missing ows_itemnumber. as i should have three crawl properties representing my three site columns .is this correct?

2- Second point. not sure what does ows_q_txt_ItemNumber crawl property represent? As it is mapped to a manged property unlike the other properties . and inside my Content Search web part when i wrote the following inside my query ItemNumberOWSTEXT:-T- i got results from the 3 site collections items , where these items have their "item number" contain -T-?? so not sure what is going on !!

  • 1
    In the search admin center in central administration is where all of this schema is defined – Eric Alexander Sep 28 '16 at 15:48
  • 1
    The crawled properties are the site columns. If you go to Central Admin, manage the Search Service, and look at crawled properties, you will see a filter drop down. Choose "SharePoint", and you should see crawled properties that represent the site columns. In general they have a naming pattern of "ows_FieldInternalName". – Dylan Cristy Sep 28 '16 at 16:31
  • 1
    Regarding your additional question 1 - I don't think there would be two with the same name, even though you have two columns in two different site collections, they have the same internal name, so there will be only one crawled property with that name. Regarding your second question - seems like the "...q_TEXT..." are autogenerated by SharePoint as part of the process of generating managed properties. See this article that explains the process a bit. – Dylan Cristy Sep 28 '16 at 17:02
  • 1
    Regarding why you get results from all three site collections - I think that's the way it's supposed to work. You should be able to aggregate content from multiple site collections through Search. If you want your results to only come from a particular site collection, you will have to do some other kind of filtering in the CSWP, either by setting up a result source, or using "PATH" in the query itself. – Dylan Cristy Sep 28 '16 at 17:07
  • 1
    I don't think it's "defined" anywhere. The crawled properties and managed properties are based on column names, that's it. They don't take into account the location of the columns. So as soon as you have two site columns on two sites with the same name, that data is going to get associated with the same crawled/managed property in search. In a certain sense, you did define the aggregation by creating site columns with the same name. – Dylan Cristy Sep 28 '16 at 17:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.