Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042369Openbravo ERPA. Platformpublic2019-11-21 18:092019-12-13 09:55
Reportersanti_lozano 
Assigned Toplatform 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket13032
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042369: Query/List widget with parameters selection like a combo box, problem with selector reference
DescriptionClient wants to enter the parameters on the widget Query/List as a combo box, but as TableDir is not an option (because of reference validation), OBUISEL_Selector should be reviewed because it doesn’t let you do that purpose neither (when using it the behavior is not the expected one).
Steps To Reproduce* go to Openbravo livebuilds, role The White Valley Group, add Widget from Manage Workspace menu (main openbravo back office page, at the left) called “Best Sellers”. See that Product Name is a parameter to enter to the query just entering manually a string
* go to Widget window as system administrator. Go to its module and change it to development in order to apply the next changes
* Select in Parameter tab of Widget window Product Name entry. Change the reference field to OBUISEL_Selector Reference. As Reference Search Key enter All Products Simple Selector, also delete the default value on its field. Leave the related module not in development after saving those changes
* go to the main page with The White Valley Group, check that the widget Best Sellers field Product is not working as expected, there is no Combo Box on it searching for products

CHECK RELATED VALIDATION
* change role to System Administrator and go to Windows, Tabs & Fields. Select Widget window, go to Tab tab and select Parameter. Go to its Table “OBUIAPP_Parameter” directly by clicking on its table field link
* go to that table Column tab, then go to column “reference”, see its validation associated (that doesn’t let you select TableDir)
Proposed SolutionThe situation of this selector should be reviewed, if openbravo lets you do that, the selector option should work, if not this shouldn’t appear by adding it to the validation too
Additional Information
TagsNo tags attached.
Relationships
duplicate of design defect 0042448 acknowledged Triage Platform Base unify parameter generation for process definition and widgets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-11-21 18:09santi_lozanoNew Issue
2019-11-21 18:09santi_lozanoAssigned To => platform
2019-11-21 18:09santi_lozanoOBNetwork customer => OBPS
2019-11-21 18:09santi_lozanoModules => Core
2019-11-21 18:09santi_lozanoSupport ticket => 13032
2019-11-21 18:09santi_lozanoResolution time => 1576105200
2019-11-21 18:09santi_lozanoTriggers an Emergency Pack => No
2019-11-29 10:25alostaleStatusnew => acknowledged
2019-11-29 10:26alostaleRelationship addedrelated to 0042448
2019-11-29 10:26alostaleDescription Updatedbug_revision_view_page.php?rev_id=19833#r19833
2019-11-29 10:26alostaleProposed Solution updated
2019-11-29 10:29alostaleNote Added: 0115978
2019-12-13 09:54alostaleStatusacknowledged => scheduled
2019-12-13 09:55alostaleRelationship replacedduplicate of 0042448
2019-12-13 09:55alostaleNote Added: 0116304
2019-12-13 09:55alostaleStatusscheduled => closed
2019-12-13 09:55alostaleResolutionopen => duplicate

Notes
(0115978)
alostale   
2019-11-29 10:29   
The solution for this issue should be implemented by DD 0042448.

When defining widget parameters, it is not possible to restrict references available as widget parameters defined in the same DB structure than process definition parameters as it would apply for both cases.
(0116304)
alostale   
2019-12-13 09:55   
Marking as duplicate of 0042448 as there is no workaround fix for this case unless the whole refactor proposed there is implemented.