Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2023-10-03 11:582023-10-16 10:44
Reporterignacio_deandresView Statuspublic 
Assigned Toignacio_deandres 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Versionmain
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0053578: Filter in P&E windows having relevant characteristics and filtering having records selected

DescriptionHaving a P&E window with relevant characteristics, is not possible to filter having records selected. A NullPointerException is thrown in this case.

See attached both an example of the error and the query that is being wrongly built in this case.
Steps To Reproduce0- configure a relevant characteristic[1], for instance colour
1- add the property field pointing to this relevant characteristic in the "Offer Product Selector" window.
2- go to discounts and promotions, open add products
3- select a record and filter

[1] [^]
TagsNo tags attached.
Attached Filestxt file icon exception.txt [^] (9,687 bytes) 2023-10-03 12:37 [Show Content]
txt file icon failingQuery.txt [^] (1,125 bytes) 2023-10-03 12:37 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2023-10-03 12:29

Merge Request created: [^]
hgbot (developer)
2023-10-16 10:44

Merge request merged: [^]
hgbot (developer)
2023-10-16 10:44

Directly closing issue as related merge request is already approved.

Repository: [^]
Changeset: b93ddd3b6412681e5802152a5ef593ef0d4c71c3
Author: Carlos Aristu <>
Date: 16-10-2023 08:44:23
URL: [^]

fixes BUG-53578: wrong query with relevant charact and record selection in P&E

  A query with relevant characteristics and an or criteria in the where
clause was being wrongly build, causing a NPE when it was executed.

  This was reproducible having a P&E window showing a relevant
characteristics and after trying to filter having at least one record

  Now this is fixed by ensuring that the join definition is properly
built also in this case.

M modules/org.openbravo.service.json/src/org/openbravo/service/json/

- Issue History
Date Modified Username Field Change
2023-10-03 11:58 ignacio_deandres New Issue
2023-10-03 11:58 ignacio_deandres Assigned To => Triage Platform Base
2023-10-03 11:58 ignacio_deandres Triggers an Emergency Pack => No
2023-10-03 12:21 caristu Project POS2 => Openbravo ERP
2023-10-03 12:21 caristu Modules => Core
2023-10-03 12:21 caristu Category Core => A. Platform
2023-10-03 12:29 hgbot Note Added: 0155423
2023-10-03 12:35 caristu Summary Error in the Discounts and Promotions 'add product' functionality when choosing records and filtering. => Filter in P&E windows having relevant characteristics and filtering having records selected
2023-10-03 12:35 caristu Description Updated View Revisions
2023-10-03 12:35 caristu Steps to Reproduce Updated View Revisions
2023-10-03 12:37 caristu File Added: exception.txt
2023-10-03 12:37 caristu File Added: failingQuery.txt
2023-10-03 12:37 caristu Assigned To Triage Platform Base => ignacio_deandres
2023-10-16 10:44 hgbot Note Added: 0155867
2023-10-16 10:44 hgbot Resolution open => fixed
2023-10-16 10:44 hgbot Status new => closed
2023-10-16 10:44 hgbot Fixed in Version => PR24Q1
2023-10-16 10:44 hgbot Note Added: 0155868

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker