I am building a search query inside my search content web part, as follow:-
where in my case i have three site collections:-
And inside these three site collections i have 3 site columns named "Item Number" which store a custom number for my issue tracking list items such as "Acc-T-1" ,"Fin-T-12", etc. but inside each of the three site collections the related "item number" site column does not have any relation to the other "item number" site columns.even on one site collection the internal name for the site column is
Item%5Fx0020%5FNumber while on the other site collection the internal name is
but when i define the above query mainly to return all the item that have their "Item number" contain "
-T-" i got results for all my site collections .. i though the property
ItemNumberOWSTEXT mainly represents single site column inside single site collection,, but seems it is referencing the three site columns from three site collections.
so can anyone adivce how this is happening ? and how i can check what is the property name for the site columns ?
Here is how my crawl properties are being built:-