Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023096
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2013-02-18 11:092013-03-21 10:20
ReporterjecharriView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision811136480e47
ProjectionnoneETAnoneTarget Version3.0MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned ToSandrahuguet
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023096: Product selector Is not filtering by role org access

DescriptionProduct selector Is not filtering by role org access

Steps To Reproduce-define a role with access to organization "España Región Sur"

-Login in the ERP with this role.

-Go to window "Sales order" and after create a header go to lines

-push in product selector magnifying glass and clean all the filters.

Verify that you are able to see all the prices and all the warehouses of the client.
Proposed Solutiondiff --git a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
@@ -74,7 +74,7 @@
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <NAME><![CDATA[Product]]></NAME>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <AD_REFERENCE_ID><![CDATA[800060]]></AD_REFERENCE_ID>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <AD_TABLE_ID><![CDATA[FF8080812DFFA1CF012DFFB889F40016]]></AD_TABLE_ID>
-<!--2E64F551C7C4470C80C29DBA24B34A5F--> <WHERECLAUSE><![CDATA[e.active='Y']]></WHERECLAUSE>
+<!--2E64F551C7C4470C80C29DBA24B34A5F--> <WHERECLAUSE><![CDATA[e.active='Y' and (AD_ISORGINCLUDED(e.warehouse.organization.id, @AD_Org_Id@, @AD_Client_Id@)<>-1 or (AD_ISORGINCLUDED( @AD_Org_Id@, e.warehouse.organization.id, @AD_Client_Id@)<>-1))]]></WHERECLAUSE>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <FILTER_EXPRESSION><![CDATA[if (OB.getParameters().get('inpcCurrencyId')){ " e.productPrice.priceListVersion.priceList.salesPriceList = " + OB.isSalesTransaction() + " AND e.productPrice.priceListVersion.priceList.currency.id = '" + OB.getParameters().get('inpcCurrencyId') + "'" }]]></FILTER_EXPRESSION>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 00233343.0MP22 closedAugustoMauch In Product Selector, when using the @ad_org_id@ in the HQL Where Clause is not working as expected. 

-  Notes
(0056972)
jonalegriaesarte (reporter)
2013-03-04 10:55

Moved to MP22 due to other priorities
(0057347)
hgbot (developer)
2013-03-21 10:18

Repository: erp/devel/pi
Changeset: 811136480e47bb540ecb968021d16fbc5162c92d
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Mar 19 18:40:04 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/811136480e47bb540ecb968021d16fbc5162c92d [^]

Fixes Issue 23096. Filters Organizations of the Product Selector
using the Organization of the Document if available.

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0057349)
Sandrahuguet (developer)
2013-03-21 10:20

Code review + testing OK

- Issue History
Date Modified Username Field Change
2013-02-18 11:09 jecharri New Issue
2013-02-18 11:09 jecharri Assigned To => dmiguelez
2013-02-18 11:09 jecharri Web browser => Google Chrome
2013-02-18 11:09 jecharri Modules => Core
2013-02-18 11:09 jecharri Resolution time => 1363820400
2013-02-18 11:09 jecharri Triggers an Emergency Pack => No
2013-02-20 08:46 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2013-02-20 14:56 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2013-03-04 10:55 jonalegriaesarte Web browser Google Chrome => Google Chrome
2013-03-04 10:55 jonalegriaesarte Note Added: 0056972
2013-03-04 10:55 jonalegriaesarte Target Version 3.0MP21 => 3.0MP22
2013-03-07 10:19 jecharri Web browser Google Chrome => Google Chrome
2013-03-07 10:19 jecharri Assigned To jecharri => AugustoMauch
2013-03-07 10:19 jecharri Category 07. Sales management => A. Platform
2013-03-11 14:00 AugustoMauch Assigned To AugustoMauch => dmiguelez
2013-03-18 20:01 dmiguelez Relationship added depends on 0023334
2013-03-18 20:01 dmiguelez Web browser Google Chrome => Google Chrome
2013-03-18 20:01 dmiguelez Proposed Solution updated
2013-03-21 10:18 hgbot Checkin
2013-03-21 10:18 hgbot Note Added: 0057347
2013-03-21 10:18 hgbot Status new => resolved
2013-03-21 10:18 hgbot Resolution open => fixed
2013-03-21 10:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/811136480e47bb540ecb968021d16fbc5162c92d [^]
2013-03-21 10:20 Sandrahuguet Review Assigned To => Sandrahuguet
2013-03-21 10:20 Sandrahuguet Note Added: 0057349
2013-03-21 10:20 Sandrahuguet Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker