details: https://code.openbravo.com/erp/devel/pi/rev/1c545be20823
changeset: 14268:1c545be20823
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Tue Nov 15 17:41:50 2011 +0100
summary: fixed bug 18564: Business Partner Selector shows inactive contacts
or addresses
diffstat:
src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (19 lines):
diff -r 5a9ee4eba052 -r 1c545be20823
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Tue Nov 15 17:33:17
2011 +0100
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Tue Nov 15 17:41:50
2011 +0100
@@ -82,11 +82,11 @@
COALESCE(contact.name, usercontact.name) as contactname,
COALESCE(contact.id, usercontact.id) as contactid,
bploc.name as locationname, bploc.id as locationid,
bp.customer as customer, bp.vendor as vendor, bp.lifetimeRevenueToDate as
income
-FROM BusinessPartner bp left join bp.businessPartnerLocationList bploc
- left join bploc.locationAddress loc
- left join bploc.aDUserList contact
+FROM BusinessPartner bp left join bp.businessPartnerLocationList bploc with
bploc.active=true
+ left join bploc.locationAddress loc with loc.active =
true
+ left join bploc.aDUserList contact with
contact.active=true
left join loc.region region
- left join bp.aDUserList usercontact with
usercontact.partnerAddress.id is null
+ left join bp.aDUserList usercontact with
usercontact.partnerAddress.id is null and usercontact.active=true
where @additional_filters@
and bp.summaryLevel = false]]></HQL>
<!--862F54CB1B074513BD791C6789F4AA42-->
<ENTITY_ALIAS><![CDATA[bp]]></ENTITY_ALIAS>
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
