Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042239Openbravo ERPZ. Otherspublic2019-11-08 14:022019-12-12 23:01
Reportersanti_lozano 
Assigned Tocberner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket12194
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042239: Combo box selector no items to show from a custom P&E process with HQL where clause applied
DescriptionThe client is reporting to us a problem related with a Pick and Excute Process (this process normally has only one parameter corresponding to the pick & execute window) that also has a business partner selector parameter.
http://wiki.openbravo.com/wiki/How_to_create_a_Pick_and_Execute_Process [^]
When it has an HQL where clause applied to the window parameter to filter by the partner selected on the selector parameter (clause is “e.businessPartner.id=@C_Bpartner_ID@”) then clicking on some combo box of the process doesn’t work (like clicking on organization arrow). The query done isn’t sending the new parameter for @C_Bpartner_ID@ ($1 or $2)
Steps To Reproduce*download openbravo locally, version tip
*add the module here given org.openbravo.client.application.examples-1.0.0.obx (extract it and copy to modules folder)
*apply ant smartbuild -Dlocal=no
*run the application, go to window Invoices P&E, select a business partner on the selector, click on the combo box of the organization column, it is showing no items
EXTRA (try the correct case):
*go as system administrator to the Windows, Tabs & Fields window, then select window Invoices P&E. Change its module to development (go to that module in order to do that, from the module link here). Delete the where clauses of Invoices P&E and save it (stop tomcat, do smartbuild, reload tomcat). Go to invoices P&E to see the organization combo box working
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? org.openbravo.client.application.examples-1.0.0.obx (16,466) 2019-11-08 14:02
https://issues.openbravo.com/file_download.php?file_id=13504&type=bug
png selector12194.png (217,046) 2019-11-08 14:15
https://issues.openbravo.com/file_download.php?file_id=13505&type=bug
png

png more001 - query differences (between good and bad execution).png (783,863) 2019-11-11 10:37
https://issues.openbravo.com/file_download.php?file_id=13511&type=bug
? more002 - good execution query (parameters alright) (16,172) 2019-11-11 10:37
https://issues.openbravo.com/file_download.php?file_id=13512&type=bug
? more003 - bad execution query (parameters problem) (22,756) 2019-11-11 10:38
https://issues.openbravo.com/file_download.php?file_id=13513&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-11-08 14:02santi_lozanoNew Issue
2019-11-08 14:02santi_lozanoAssigned To => platform
2019-11-08 14:02santi_lozanoFile Added: org.openbravo.client.application.examples-1.0.0.obx
2019-11-08 14:02santi_lozanoOBNetwork customer => No
2019-11-08 14:02santi_lozanoModules => Core
2019-11-08 14:02santi_lozanoSupport ticket => 12194
2019-11-08 14:02santi_lozanoResolution time => 1574982000
2019-11-08 14:02santi_lozanoTriggers an Emergency Pack => No
2019-11-08 14:03santi_lozanoCategoryB. User interface => Z. Others
2019-11-08 14:05santi_lozanoDescription Updatedbug_revision_view_page.php?rev_id=19646#r19646
2019-11-08 14:08santi_lozanoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19648#r19648
2019-11-08 14:15santi_lozanoFile Added: selector12194.png
2019-11-08 14:16santi_lozanoNote Added: 0115480
2019-11-11 10:37santi_lozanoFile Added: more001 - query differences (between good and bad execution).png
2019-11-11 10:37santi_lozanoFile Added: more002 - good execution query (parameters alright)
2019-11-11 10:38santi_lozanoFile Added: more003 - bad execution query (parameters problem)
2019-11-11 10:55santi_lozanoNote Added: 0115493
2019-11-12 09:38santi_lozanoOBNetwork customerNo => OBPS
2019-11-19 17:40cbernerAssigned Toplatform => cberner
2019-11-19 17:40cbernerStatusnew => scheduled
2019-11-20 08:56cbernerReview Assigned To => alostale
2019-11-22 10:54hgbotCheckin
2019-11-22 10:54hgbotNote Added: 0115770
2019-11-22 10:54hgbotStatusscheduled => resolved
2019-11-22 10:54hgbotResolutionopen => fixed
2019-11-22 10:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0e5e02a7ff59693a9a61d0ab4074fb06380d632a [^]
2019-11-29 10:02alostaleNote Added: 0115977
2019-11-29 10:02alostaleStatusresolved => closed
2019-11-29 10:02alostaleFixed in Version => 3.0PR20Q1
2019-12-12 23:01hudsonbotCheckin
2019-12-12 23:01hudsonbotNote Added: 0116288

Notes
(0115480)
santi_lozano   
2019-11-08 14:16   
image attached to show the elements of Invoices P&E
1:selector parameter
2:window parameter
3:organization combo box
(0115493)
santi_lozano   
2019-11-11 10:55   
Added 3 more images (more001, more002, more003) showing the differences on the query that are thrown for the good and bad executions (on the text files you can see that the parameters are not passed correctly $1 and $2)
(0115770)
hgbot   
2019-11-22 10:54   
Repository: erp/devel/pi
Changeset: 0e5e02a7ff59693a9a61d0ab4074fb06380d632a
Author: Cristian Berner <cristian.berner <at> openbravo.com>
Date: Fri Nov 22 10:54:18 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0e5e02a7ff59693a9a61d0ab4074fb06380d632a [^]

Fixes issue 42239: Combo box works correctly in P&E process with HQL clause
Combo box selectors in P&E process with HQL where clause now work correctly,
context attributes are sent in the request correctly, previously those were missing

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-combo.js
---
(0115977)
alostale   
2019-11-29 10:02   
tested
reviewed: https://gitlab.com/openbravocode/product/openbravo/merge_requests/18 [^]
(0116288)
hudsonbot   
2019-12-12 23:01   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/954d2b7a66fb [^]
Maturity status: Test