Re: [fossil-users] Ordering ticket priority/severity

2014-10-13 Thread org.fossil-scm.fossil-users
On 2014-10-13T06:40:37 +0100 Jacek Cała jacek.c...@gmail.com wrote: Hi, Below is one of my ticket report pages. I'm not entirely sure it's the best approach but works fine for me. What it does is two selects. The inner select classifies status, priority, severity and difficulty so then I

[fossil-users] Ordering ticket priority/severity

2014-10-12 Thread org.fossil-scm.fossil-users
'Lo. Currently, if I do, in a ticket report: ORDER BY priority, severity I definitely get something ordered by priority and severity, but of course the ordering relation for both columns is lexicographical. That is, Important Critical because Critical appears earlier in the alphabet. That's

Re: [fossil-users] Ordering ticket priority/severity

2014-10-12 Thread tonyp
-users] Ordering ticket priority/severity 'Lo. Currently, if I do, in a ticket report: ORDER BY priority, severity I definitely get something ordered by priority and severity, but of course the ordering relation for both columns is lexicographical. That is, Important Critical because Critical

Re: [fossil-users] Ordering ticket priority/severity

2014-10-12 Thread Jacek Cała
Hi, Below is one of my ticket report pages. I'm not entirely sure it's the best approach but works fine for me. What it does is two selects. The inner select classifies status, priority, severity and difficulty so then I can order them appropriately. The outer select presents the data in human