Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0035588 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 01. General setup | minor | always | 2017-03-21 17:56 | 2019-01-14 17:07 | |||||||
| Reporter | aaroncalero | View Status | public | |||||||||
| Assigned To | markmm82 | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | OBPS | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | 50419 | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0035588: The hqlfilterclause of the User window doesn't match the sql filterclause | |||||||||||
| Description | The 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 Reproduce | Verify 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 Solution | Replace the bp.salesRepresentative='Y' clause of the hqlfilterclause with: bp.isSalesRepresentative='Y' | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 2017-03-21 17:56 | aaroncalero | Modules | => Core |
| 2017-03-21 17:56 | aaroncalero | Triggers an Emergency Pack | => No |
| 2018-01-11 11:05 | ngarcia | OBNetwork customer | No => Yes |
| 2018-01-11 11:05 | ngarcia | Support ticket | => 50419 |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |