29 |
foreach my $c ( qw/name created_on owner/ ) { |
foreach my $c ( qw/name created_on owner/ ) { |
30 |
#next if ($c eq $order); |
#next if ($c eq $order); |
31 |
$sort_menu->child( $c, |
$sort_menu->child( $c, |
32 |
#active => $c eq $order, |
active => $c eq $order, |
33 |
link => Jifty->web->link( |
link => Jifty->web->link( |
34 |
label => $sort_label->{$c}, |
label => $sort_label->{$c}, |
35 |
onclick => { |
onclick => { |
60 |
) if ($created_on); |
) if ($created_on); |
61 |
|
|
62 |
# select created_on,count(date(created_on)) from queries group by date(created_on) order by created_on; |
# select created_on,count(date(created_on)) from queries group by date(created_on) order by created_on; |
63 |
my $date_coll = SQLSession::Model::QueryCollection->new(); |
my $date_coll = SQLSession::Model::QueryCollection->new( results_are_readable => 1 ); |
64 |
my $created_on_date = $date_coll->column( function => 'date(created_on)', column => 'date' ); |
my $created_on_date = $date_coll->column( function => 'date(created_on)', column => 'date' ); |
65 |
my $count = $date_coll->column( function => 'count(date(created_on))', column => 'count' ); |
my $count = $date_coll->column( function => 'count(date(created_on))', column => 'count' ); |
66 |
$date_coll->group_by( function => $created_on_date ); |
$date_coll->group_by( function => $created_on_date ); |