Refactors navigation page generation. Adds navigation by Series.

[quanlib.git] / store.rb

diff --git a/store.rb b/store.rb
index 0ba3447e8807051c923b258cfcbf9f4270d398b3..05f44132d1609af54f4cbb3e47befc69161fbce3 100644 (file)
--- a/store.rb
+++ b/store.rb
@@ -393,9 +393,10 @@ EOS
   def query_series_by_age(pattern)
     sql = 
 <<EOS
-      SELECT s.id FROM Series s
+      SELECT s.id 
+      FROM Series s
       WHERE s.age LIKE $1
-      ORDER BY s.descr
+      ORDER BY s.grouping,s.descr
 EOS
     series_ids = []
     @conn.exec_params(sql, [pattern]) do |rs|