Boolean custom column values

[sengian]

Hello,

when using a tristate custom column I am not able to sort it using Y or N value. Could anyone explain me why not?

Thanks

[theducks]

Originally Posted by sengian

Hello,

when using a tristate custom column I am not able to sort it using Y or N value. Could anyone explain me why not?

Thanks

Works on XP ascending Sorts: True, False, un-defined
Did you restart after creation?

[sengian]

Originally Posted by theducks

Works on XP ascending Sorts: True, False, un-defined
Did you restart after creation?

Yes for me also, my problem is with search, i can use #mycolumn:true, but not the state. I tried true, Y, N,... as values but nothing is working.
I didn't find anything in the help about this but I may have missed something.

[theducks]

Originally Posted by sengian

Yes for me also, my problem is with search, i can use #mycolumn:true, but not the state. I tried true, Y, N,... as values but nothing is working.
I didn't find anything in the help about this but I may have missed something.

That is Searching, not sorting.
Click the column header to sort

To search gets trickier
Not #mycolumn:true for unset

Yes/no custom columns are searchable. Searching for false, empty, or blank will find all books with undefined values in the column. Searching for true will find all books that do not have undefined values in the column. Searching for yes or checked will find all books with Yes in the column. Searching for no or unchecked will find all books with No in the column. Note that the words yes, no, blank, empty, checked and unchecked are translated; you must use the current language’s equivalent word. The words true and false and the special values _yes and _no are not translated.

[sengian]

Thanks, I missed the translation of yes and no.
I will keep it in mind.