projects
/
BackupPC.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2c835fe
)
hide scheduled without option
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Fri, 28 Jan 2011 16:48:15 +0000
(17:48 +0100)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Fri, 28 Jan 2011 16:48:15 +0000
(17:48 +0100)
lib/BackupPC/Search.pm
patch
|
blob
|
history
diff --git
a/lib/BackupPC/Search.pm
b/lib/BackupPC/Search.pm
index
ad27bb1
..
b4b69c9
100644
(file)
--- 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 );