Index: openacs-4/packages/invoices/lib/report-day-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/report-day-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/invoices/lib/report-day-postgresql.xql 7 Sep 2005 16:51:55 -0000 1.2 +++ openacs-4/packages/invoices/lib/report-day-postgresql.xql 7 Sep 2005 18:28:24 -0000 1.3 @@ -20,8 +20,8 @@ and to_char(due_date, 'MM') = :month and r.revision_id = i.latest_revision and iv.invoice_id = r.revision_id - and iv.organization_id = :organization_id and iv.recipient_id = o.object_id + $extra_query [template::list::filter_where_clauses -and -name iv_days] [template::list::orderby_clause -name iv_days -orderby] @@ -36,7 +36,7 @@ where to_char(due_date, 'MM') = :month and to_char(due_date, 'YYYY') = :year - and organization_id = :organization_id + $extra_query