View Single Post
Old 07-22-2020, 01:03 PM   #3
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,476
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
I was able to get the sort the way I wanted by using composite column.

Code:
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):
Code:
program:
	f = field('#columnname');
	test(f, f, 'zzzzzzzzz')
chaley is offline   Reply With Quote