From cf509d99ebd41c1580e7fa3513ddd9dcdd93a849 Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Fri, 28 Jan 2011 17:48:15 +0100
Subject: [PATCH] hide scheduled without option

---
 lib/BackupPC/Search.pm | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/lib/BackupPC/Search.pm b/lib/BackupPC/Search.pm
index ad27bb1..b4b69c9 100644
--- a/lib/BackupPC/Search.pm
+++ b/lib/BackupPC/Search.pm
@@ -398,6 +398,13 @@ print STDERR "## sort=". ($param->{'sort'} || 'no sort param') . " burn sql orde
 		LEFT OUTER JOIN archive_parts  ap ON ap.backup_part_id = p.id
 		LEFT OUTER JOIN archive_burned ab ON ab.archive_id = ap.archive_id
 		GROUP BY p.id,filename,b.date,age,p.size,p.part_nr
+	};
+
+	$sql .= qq{
+		HAVING count(ap.*) = 0
+	} unless $param->{scheduled};
+
+	$sql .= qq{
 		ORDER BY b.date,p.part_nr
 	};
 	my $sth = $dbh->prepare( $sql );
-- 
2.20.1