SharePoint Online: Add an boolean refiner to classical search

%3CLINGO-SUB%20id%3D%22lingo-sub-643882%22%20slang%3D%22en-US%22%3ESharePoint%20Online%3A%20Add%20an%20boolean%20refiner%20to%20classical%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643882%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe've%20implemented%20an%20boolean%20archive%20flag%20that%20marks%20archived%20files%20with%20yes.%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20add%20a%20refiner%20to%20classical%20search%20to%20show%3A%3C%2FP%3E%3CP%3E-%20not%20archived%3C%2FP%3E%3CP%3E-%20archived%3C%2FP%3E%3CP%3E-%20both%3C%2FP%3E%3CP%3EFiles.%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20for%20the%20%22not%20archived%22%20case%20I%20need%20something%20like%20%22Show%20me%20all%20files%20with%20archive%20flag%20equals%20false%20or%20not%20defined%22.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20implement%20this%20with%20a%20simple%20approach%3F%20My%20internet%20research%20doesn't%20give%20me%20a%20helpful%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20advice%2C%3C%2FP%3E%3CP%3EIngrid%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-643882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eclassic%20experience%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERefiners%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-645400%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%3A%20Add%20an%20boolean%20refiner%20to%20classical%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F159101%22%20target%3D%22_blank%22%3E%40Ingrid%20Schiele%3C%2FA%3EAFAIK%20SharePoint%20boolean%20or%20Yes%2FNo%20fields%20cannot%20hold%20empty%20values.%20During%20column%20creation%20you%20always%20have%20to%20set%20a%20default%20value%20.%20Could%20you%20check%20what%20is%20the%20default%20value%20for%20that%20column%2C%20maybe%20its%20already%20set%20to%20NO%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20scenario%20for%20empty%20values%20can%20be%20if%20the%20yes%2Fno%20field%20was%20added%20to%20the%20list%20at%20a%20later%20point%20of%20time%20and%20then%20the%20existing%20items%20will%20have%20empty%20values.%20Is%20that%20the%20case%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776532%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%3A%20Add%20an%20boolean%20refiner%20to%20classical%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776532%22%20slang%3D%22en-US%22%3EThanks%20for%20reply%2C%20unnie.%20Sorry%20for%20the%20late%20response.%20I%20didn't%20receive%20a%20message%20that%20theres%20a%20reply%20for%20my%20post.%3CBR%20%2F%3E%3CBR%20%2F%3EYes%2C%20the%20field%20was%20added%20to%20library%20at%20a%20later%20point%20of%20time.%3CBR%20%2F%3EThat%20means%20if%20I%20want%20to%20use%20this%20Refiner%20I%20have%20to%20update%20all%20existant%20files%3F%3CBR%20%2F%3EI%20don't%20want%20to%20do%20that%20because%20the%20files%20becomed%20modified%20and%20the%20user%20are%20confused%20why.%20They're%20just%20interested%20in%20changes%20of%20file%20content%20not%20Metadata%20%3A-).%3CBR%20%2F%3EIs%20there%20a%20way%20to%20change%20the%20metadata%20without%20effect%20on%20the%20modify%20date%3F%3CBR%20%2F%3ERegards%3CBR%20%2F%3EIngrid%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

we've implemented an boolean archive flag that marks archived files with yes.

Now I want to add a refiner to classical search to show:

- not archived

- archived

- both

Files.

My problem is that for the "not archived" case I need something like "Show me all files with archive flag equals false or not defined".

Is it possible to implement this with a simple approach? My internet research doesn't give me a helpful answer.

 

Thanks for any advice,

Ingrid

 

 

2 Replies
Highlighted

@Ingrid SchieleAFAIK SharePoint boolean or Yes/No fields cannot hold empty values. During column creation you always have to set a default value . Could you check what is the default value for that column, maybe its already set to NO?

 

Only scenario for empty values can be if the yes/no field was added to the list at a later point of time and then the existing items will have empty values. Is that the case here?

Highlighted
Thanks for reply, unnie. Sorry for the late response. I didn't receive a message that theres a reply for my post.

Yes, the field was added to library at a later point of time.
That means if I want to use this Refiner I have to update all existant files?
I don't want to do that because the files becomed modified and the user are confused why. They're just interested in changes of file content not Metadata :-).
Is there a way to change the metadata without effect on the modify date?
Regards
Ingrid