May 24 2019 06:24 AM
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
May 24 2019 03:40 PM - edited May 24 2019 03:43 PM
@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?
Jul 28 2019 07:51 AM