From 0d18dcfbb87c8dc6a41a8b4551b1d67796cae8d7 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Thu, 3 Oct 2013 10:28:37 -0400 Subject: [PATCH] Ignore BRE.id = -1. Add to the where condition in Marque::Biblio::build_query to make sure that bre.id > 0. Signed-off-by: Jason Stephenson --- Open-ILS/src/support-scripts/Marque.pm.in | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/support-scripts/Marque.pm.in b/Open-ILS/src/support-scripts/Marque.pm.in index 36ac1cd6ff..8e5ab93a42 100644 --- a/Open-ILS/src/support-scripts/Marque.pm.in +++ b/Open-ILS/src/support-scripts/Marque.pm.in @@ -388,14 +388,14 @@ ACN_JOIN } # The where really depends on a few options: - my $where = 'where '; + my $where = "where $breTable.id > 0 and "; # We fill in the where as necessary. if ($self->{idlist} && @{$self->{idlist}}) { $where .= "$breTable.id in (" . join(',', @{$self->{idlist}}) . ')'; } elsif ($Marque::config->option_value('since')) { my $since_str = Marque::Connector::db_date($self->{since_date}); - $where .= "$breTable.edit_date > '$since_str'"; - $where .= " or $breTable.create_date > '$since_str'"; + $where .= "($breTable.edit_date > '$since_str'"; + $where .= " or $breTable.create_date > '$since_str')"; } else { # We want all non-deleted records. $where .= "$breTable.deleted = 'f'"; -- 2.11.0