Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035588 | Openbravo ERP | 01. General setup | public | 2017-03-21 17:56 | 2019-01-14 17:07 |
| Reporter | aaroncalero | ||||
| Assigned To | markmm82 | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | scheduled | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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' | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| There are no notes attached to this issue. |