Sort by multiple fields

1

Hi,

How can I sort the listview with more than one fields?

I have a category having values in 1,2,3,4…
and sub category having values in A,B,C,D…

In the doctype, I added sort field as category. Now my category is sorted like 1,2,3,4,…
but i have to sort by subcategory too,. bcoz it’s listed in order B,A,D,C under 1. like 1B,1A,1D,1C,2C,2D,2A,2B… I want it in the order 1A,1B,1C,1D,2A,2B,2C…

So my list looks awful. So please do help

1 Like
2

Interesting question and following it.

Not related to your question but, how did you make the list view for your doctype? I am struggling to create mine.