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 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 can > order them

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 r

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" > "Crit

[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.