Quote:
Originally Posted by ownedbycats
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')