details: /erp/devel/pi/rev/1f6ef3054d8d
changeset: 11450:1f6ef3054d8d
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Mon Apr 04 13:01:35 2011 +0200
summary: Fixed issue 16407.Fixed left join constraint.
diffstat:
src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
diffs (14 lines):
diff -r d4d323769d43 -r 1f6ef3054d8d
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Mon Apr 04 12:42:30
2011 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Mon Apr 04 13:01:35
2011 +0200
@@ -56,9 +56,8 @@
left join bploc.locationAddress loc
left join bploc.aDUserList contact
left join loc.region region
- left join bp.aDUserList usercontact
+ left join bp.aDUserList usercontact with
usercontact.partnerAddress.id is null
where @additional_filters@
- and usercontact.partnerAddress is null
and bp.summaryLevel = false]]></HQL>
<!--862F54CB1B074513BD791C6789F4AA42-->
<ENTITY_ALIAS><![CDATA[bp]]></ENTITY_ALIAS>
<!--862F54CB1B074513BD791C6789F4AA42-->
<CUSTOM_QUERY><![CDATA[Y]]></CUSTOM_QUERY>
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
