I find it confusing that the sorting order is either false-true-null or null-true-false when I sort on bools.
I often miss out on completed checkboxes because of this. In Appfarm I need to tables on bool == true.
Is this possible to change or is this default behavior? I see this is also the case in Dev Tools. I would at least expect true-false-null, and either false-true-null or null-false-true.
The current implementation sorts tri-state values (false, true, undefined) alphanumerically, which I think technically is correct.
To achieve a two-state sort (false, true), required and default false can be applied to the OC property. This eliminates the ‘undefined’ state from the sorting process.
However, we acknowledge that this approach might not be intuitive. We are currently exploring more user-friendly configuration options for future releases to enhance this functionality.