From: garyhgohoos <gary@xtuple.com>
Date: Fri, 3 Oct 2014 17:35:40 +0000 (-0400)
Subject: Issue #24684:add filter for funds type
X-Git-Url: http://git.roojs.org/?p=xtuple;a=commitdiff_plain;h=c3333751a60f6e520c3b996548171e9e088693fe

Issue #24684:add filter for funds type
---

diff --git a/foundation-database/public/tables/metasql/cashReceipts-detail.mql b/foundation-database/public/tables/metasql/cashReceipts-detail.mql
index 0464b981d..b365f97eb 100644
--- a/foundation-database/public/tables/metasql/cashReceipts-detail.mql
+++ b/foundation-database/public/tables/metasql/cashReceipts-detail.mql
@@ -221,6 +221,9 @@ WHERE ( (cashrcpt_distdate BETWEEN <? value("startDate") ?> AND <? value("endDat
   AND   (custgrpitem_custgrp_id=<? value("custgrp_id") ?>)
 <? elseif exists("custtype_pattern") ?>
   AND   (cust_custtype_id IN (SELECT custtype_id FROM custtype WHERE (custtype_code ~ <? value("custtype_pattern") ?>)))
+<? endif ?>
+<? if exists("fundstype") ?>
+  AND   (cashrcpt_fundstype=<? value("fundstype") ?>)
 <? endif ?>
       )
 
@@ -260,6 +263,9 @@ WHERE ( (cashrcpt_distdate BETWEEN <? value("startDate") ?> AND <? value("endDat
   AND   (custgrpitem_custgrp_id=<? value("custgrp_id") ?>)
 <? elseif exists("custtype_pattern") ?>
   AND   (cust_custtype_id IN (SELECT custtype_id FROM custtype WHERE (custtype_code ~ <? value("custtype_pattern") ?>)))
+<? endif ?>
+<? if exists("fundstype") ?>
+  AND   (cashrcpt_fundstype=<? value("fundstype") ?>)
 <? endif ?>
       )
 
@@ -291,6 +297,9 @@ WHERE ( (cashrcpt_distdate BETWEEN <? value("startDate") ?> AND <? value("endDat
   AND   (custgrpitem_custgrp_id=<? value("custgrp_id") ?>)
 <? elseif exists("custtype_pattern") ?>
   AND   (cust_custtype_id IN (SELECT custtype_id FROM custtype WHERE (custtype_code ~ <? value("custtype_pattern") ?>)))
+<? endif ?>
+<? if exists("fundstype") ?>
+  AND   (cashrcpt_fundstype=<? value("fundstype") ?>)
 <? endif ?>
       )
   ) AS data