Sorting and undefined values

[ownedbycats]

When sorting a column A-Z, all the books with an undefined value in that column sort to the top. Aside from using columnname:true or using composite columns (still figuring out the template language), are there any workarounds to make them sort to the bottom while preserving the alphabetical order?

[ownedbycats]

I was able to get the sort the way I wanted by using composite column.

program: 
	test(field('#columnname'), 'Yes', '')

First I sorted A-Z by the column, then I sorted by the composite column so that all the Yeses were on top. A bit kludgey but it works.

[chaley]

Originally Posted by ownedbycats

I was able to get the sort the way I wanted by using composite column.

program: 
	test(field('#columnname'), 'Yes', '')

First I sorted A-Z by the column, then I sorted by the composite column so that all the Yeses were on top. A bit kludgey but it works.

Isn't using a saved search '#columnname:true' then sorting the column easier and more visually pleasing? Or if VLs are tabs, create a VL for '#columnname:true' then sort? Of course these "solutions" assume you don't want to see the non-Yes lines.

If you know a maximum value for a column, perhaps a composite field like this is better (assuming a text column):

program:
	f = field('#columnname');
	test(f, f, 'zzzzzzzzz')

[ownedbycats]

It was mostly for View Manager sorting purposes. It does have the option to filter to a saved search but I also wanted to see the non-Yes books too. I might try that other column though.