Search on a Site column does not return results

%3CLINGO-SUB%20id%3D%22lingo-sub-1419505%22%20slang%3D%22en-US%22%3ESearch%20on%20a%20Site%20column%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419505%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20on%20O365%20and%20have%20a%20search%2F%20index%20issue%20or%20perhaps%20it%20just%20is%20not%20possible%3F%3C%2FP%3E%3CP%3EMy%20goal%3A%20find%20values%20in%20(classic)%20search%20site%20that%20are%20entered%20in%20Site%20Columns%20(single%20line%20of%20text)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20We%20use%20a%20content%20type%20hub%2C%20the%20site%20columns%20are%20created%20here%20and%20inserted%20in%20a%20content%20type%3C%2FP%3E%3CP%3E-%20The%20site%20columns%20are%20single%20line%20of%20text%3C%2FP%3E%3CP%3E-%20The%20site%20columns%2Fcrawled%20properties%20(ows_columnname)%26nbsp%3B%20are%20mapped%20to%20existing%20refinablestring00%2C%20refinablestring01%20etc.%20I%20have%20not%20created%20managed%20properties%20but%20used%20the%20existing%20ones.%3C%2FP%3E%3CP%3E-%20crawled%20properties%20have%20checked%20the%20option%20%22include%20in%20full%20text%20index%22%3C%2FP%3E%3CP%3E-%20Have%20created%20a%20site%2C%20content%20types%20are%20distributed%20to%20the%20sites%3C%2FP%3E%3CP%3E-%20Have%20uploaded%20test%20content%20(Word%2F%20PDF%20files)%20and%20filled%20the%20site%20columns%20with%20values%3C%2FP%3E%3CP%3E-%20In%20the%20search%20site%3A%20added%20the%20site%20columns%20as%20refinement%20property%3C%2FP%3E%3CP%3E-%20When%20searching%20on%20the%20test%20file%20name%20I%20can%20find%20the%20files%26nbsp%3B%3C%2FP%3E%3CP%3E-%20When%20searching%20on%20values%20that%20exist%20in%20the%20columns%20I%20find%20nothing%3C%2FP%3E%3CP%3E-%20When%20searching%20specific%20on%20the%20site%20column%20names%20I%20find%20the%20values%20(%22refinablestring08%3A%20chili%22%20for%20example%20finds%20the%20document)%3C%2FP%3E%3CP%3E-%20I%20have%20re-indexed%20the%20library%2C%20the%20same%20with%20the%20site%20to%20be%20sure.%3C%2FP%3E%3CP%3E-%20We%20use%20a%20default%20search%20site%2C%20no%20extra%20search%20scopes%20are%20created%3C%2FP%3E%3CP%3E-%20It%20is%20a%20new%20O365%20environment%2C%20until%20now%20we%20just%20have%20two%20sites%20in%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20understand%20why%20I%20can't%20find%20results%20if%20I%20search%20on%20values%20in%20the%20columns%20but%20if%20I%20search%20specific%20on%20the%20columnname%20I%20can%20find%20the%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20suggestion%20if%20I%20am%20doing%20something%20wrong%3F%20At%20this%20point%20I%20do%20not%20know%20how%20to%20solve%20this%3F%20Only%20thing%20I%20am%20thinking%20if%20a%20column%20of%20the%20type%20single%20linke%20of%20text%20is%20the%20way%20to%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJuan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1419505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Senior Member

Hi Community, 

 

We are on O365 and have a search/ index issue or perhaps it just is not possible?

My goal: find values in (classic) search site that are entered in Site Columns (single line of text)

 

- We use a content type hub, the site columns are created here and inserted in a content type

- The site columns are single line of text

- The site columns/crawled properties (ows_columnname)  are mapped to existing refinablestring00, refinablestring01 etc. I have not created managed properties but used the existing ones. Mapping has been done in the SP admin portal (I have the SP admin role)

- crawled properties have checked the option "include in full text index"

- Have created a site, content types are distributed to the sites

- Have uploaded test content (Word/ PDF files) and filled the site columns with values

- In the search site: added the site columns as refinement property

- When searching on the test file name I can find the files 

- When searching on values that exist in the columns I find nothing

- When searching specific on the site column names I find the values ("refinablestring08: chili" for example finds the document)

- I have re-indexed the library, the same with the site to be sure.

- We use a default search site, no extra search scopes are created

- It is a new O365 environment, until now we just have two sites in use.

 

I do not understand why I can't find results if I search on values in the columns but if I search specific on the columnname I can find the values.

 

Do you have a suggestion if I am doing something wrong? At this point I do not know how to solve this? Only thing I am thinking if a column of the type single linke of text is the way to use?

 

Thank you for your help!

 

Kind regards,

 

Juan