MobileRead Forums - View Single Post

ownedbycats · 07-22-2020, 11:59 AM

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.

07-22-2020, 11:59 AM	#2
ownedbycats Custom User Title Posts: 11,023 Karma: 75555555 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	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.