From f1a6cb69d064ea81e51f6bc29e2cdb7d695980a6 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 28 Oct 2005 11:56:48 +0000 Subject: don't show 'N/A' statustext as a failed billing event --- httemplate/search/cust_bill_event.cgi | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'httemplate/search/cust_bill_event.cgi') diff --git a/httemplate/search/cust_bill_event.cgi b/httemplate/search/cust_bill_event.cgi index df4dcbf42..a21fb1912 100644 --- a/httemplate/search/cust_bill_event.cgi +++ b/httemplate/search/cust_bill_event.cgi @@ -15,7 +15,9 @@ my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi); my $where = " WHERE cust_bill_event._date >= $beginning". " AND cust_bill_event._date <= $ending"; -$where .= " AND statustext != '' AND statustext IS NOT NULL" +$where .= " AND statustext != '' ". + " AND statustext IS NOT NULL ". + " AND statustext != 'N/A' " if $cgi->param('failed'); my $sql_query = { -- cgit v1.2.1