From c3333751a60f6e520c3b996548171e9e088693fe Mon Sep 17 00:00:00 2001
From: garyhgohoos <gary@xtuple.com>
Date: Fri, 3 Oct 2014 13:35:40 -0400
Subject: [PATCH] Issue #24684:add filter for funds type

---
 .../public/tables/metasql/cashReceipts-detail.mql        | 9 +++++++++
 1 file changed, 9 insertions(+)

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
-- 
2.39.2