--- trunk/share/web/templates/index.html 2006/12/03 19:47:39 21 +++ trunk/share/web/templates/list 2007/01/18 18:55:17 41 @@ -1,6 +1,19 @@ +<%args> +$database_id => undef +%args> <%init> my $queries = SQLSession::Model::QueryCollection->new(); -$queries->unlimit(); + +my $edit = Jifty->config->app('edit'); +if ( $edit ) { + $queries->unlimit; +} else { + $queries->limit( column => 'visible', value => 1 ); +} +$queries->limit( column => 'on_database', value => $database_id ) if ( $database_id ); +$queries->order_by( column => 'name', order => 'asc' ); + +warn $queries->build_select_query; %init> @@ -10,15 +23,30 @@
- <% $q->sql_query %> -+% if ($q->note) { +
<% $q->sql_query %>