--- trunk/share/web/templates/list	2006/12/07 19:56:41	28
+++ trunk/share/web/templates/list	2007/01/18 17:02:24	38
@@ -1,6 +1,13 @@
 <%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->order_by( column => 'name', order => 'asc' );
 
 </%init>
 
@@ -10,14 +17,25 @@
 	<dt><% Jifty->web->tangent(
 		url => '/sql/' . $q->id,
 		label => $q->name,
-	) %></dt>
+	) %>
+
+	<span class="database-name">on <% $q->on_database->name %>
+% if ( $edit ) {
+	<tt>[<% $q->on_database->dsn %>]</tt>
+% }
+	</span>
+
+	</dt>
 	<dd>
-	<pre class="sql"><% $q->sql_query %></pre>
+% if ($q->note) {
 	<div class="sql-note"><% $q->note %></div>
-	<div class="database-name">on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt></div>
+% }
+	<pre class="sql"><% $q->sql_query %></pre>
 	</dd>
 % }
 </dl>
 </&>
 
+% if ( $edit ) {
 <% Jifty->web->tangent( url => '/new', label => 'New SQL query' ) %>
+% }