aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormatthew <matthew>2009-02-10 12:06:16 +0000
committermatthew <matthew>2009-02-10 12:06:16 +0000
commit36d5dafe39198244ac4fb43b8baacef8d55da3cc (patch)
treeecd7de10ccf158c816c80d1418f617b7f15660d9
parentdd522be47e123ad5a107128e10b2513b1a1d2b54 (diff)
Sort by created by default.
-rwxr-xr-xweb-admin/index.cgi6
1 files changed, 3 insertions, 3 deletions
diff --git a/web-admin/index.cgi b/web-admin/index.cgi
index df58a4743..9bc681447 100755
--- a/web-admin/index.cgi
+++ b/web-admin/index.cgi
@@ -7,10 +7,10 @@
# Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved.
# Email: francis@mysociety.org; WWW: http://www.mysociety.org/
#
-# $Id: index.cgi,v 1.65 2009-01-22 10:12:40 matthew Exp $
+# $Id: index.cgi,v 1.66 2009-02-10 12:06:16 matthew Exp $
#
-my $rcsid = ''; $rcsid .= '$Id: index.cgi,v 1.65 2009-01-22 10:12:40 matthew Exp $';
+my $rcsid = ''; $rcsid .= '$Id: index.cgi,v 1.66 2009-02-10 12:06:16 matthew Exp $';
use strict;
@@ -428,7 +428,7 @@ sub admin_reports {
email, anonymous, created, confirmed, state, service, lastupdate,
whensent, send_questionnaire from problem where id=? or email ilike
'%'||?||'%' or name ilike '%'||?||'%' or title ilike '%'||?||'%' or
- detail ilike '%'||?||'%' or council like '%'||?||'%'", int($search),
+ detail ilike '%'||?||'%' or council like '%'||?||'%' order by created", int($search),
$search, $search, $search, $search, $search);
print $q->start_table({border=>1, cellpadding=>2, cellspacing=>0});
print $q->th({}, ['ID', 'Title', 'Name', 'Email', 'Council', 'Category', 'Anonymous', 'Created', 'State', 'When sent', '*']);