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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035588
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2017-03-21 17:562019-01-14 17:07
ReporteraaroncaleroView Statuspublic 
Assigned Tomarkmm82 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035588: The hqlfilterclause of the User window doesn't match the sql filterclause

DescriptionThe User window by default filters users which are not "real users" of the application, that is, it filters the users which are related with a business partner which is neither a sales representative nor an employee.

Steps To ReproduceVerify the AD_TAB definition for the User window: https://code.openbravo.com/erp/devel/pi/file/5df11a528146/src-db/database/sourcedata/AD_TAB.xml#l521, [^] especifically the filterclause and the hqlfilterclause:
>> <!--118--> <FILTERCLAUSE><![CDATA[(EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND (bp.IsEmployee='Y' OR bp.IsSalesRep='Y')) OR AD_User.C_BPartner_ID IS NULL)]]></FILTERCLAUSE>

>> <!--118--> <HQLFILTERCLAUSE><![CDATA[e.businessPartner.id in (select id from BusinessPartner bp where bp.employee='Y' or bp.salesRepresentative='Y') or e.businessPartner is null]]></HQLFILTERCLAUSE>

The hqlfilterclause is referencing the salesRepresentative column of the businesspartner, which maps to the sql SalesRep_ID column, instead of the isSalesRepresentative which is the correct IsSalesRep column.
Proposed SolutionReplace the bp.salesRepresentative='Y' clause of the hqlfilterclause with:
bp.isSalesRepresentative='Y'
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-03-21 17:56 aaroncalero New Issue
2017-03-21 17:56 aaroncalero Assigned To => Triage Finance
2017-03-21 17:56 aaroncalero Modules => Core
2017-03-21 17:56 aaroncalero Triggers an Emergency Pack => No
2018-01-11 11:06 ngarcia Issue Monitored: networkb
2018-01-11 11:06 ngarcia Issue Monitored: ngarcia
2019-01-08 14:44 Sandrahuguet Assigned To Triage Finance => markmm82
2019-01-14 17:07 markmm82 Status new => scheduled


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker