Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045818Openbravo ERP00. Application dictionarypublic2021-01-29 14:082021-01-29 14:14
Reportershuehner 
Assigned ToTriage Finance 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045818: Tracking issue: Modules adding tabs with same tablevel & seqno as an existing tab should be fixed
DescriptionHaving 2 tabs with same tablevel and seqno values causes 3 problems

a.) The Order in UI is undefined as tabs are ordered by seqno
b.) It is not possible to add subtabs having those as parent tabs as sub-tab/parent-tab link is via seqno and this 'double parent' makes it impossible to define which is the 'correct parent'
c.) junit test IndexesTest.testSubTabs fails with 'subquery returns more than on row' when trying to calculate 'the' parent (and >1 parent exists.

This issue is to track the known cases for maintained modules (from merged.json set) to start checking and fixing those are cases over time.
Steps To ReproduceList which is attached to this issue can be re-recreating by running following query:
- Essentially just ad_tab group by ad_window_id, tablevel, seqno
- Then adding some extra columns for the output

select (select javapackage from ad_module where ad_module.ad_module_id = win.ad_module_id) as win_module, win.ad_window_id, win.isactive, win.name, (select javapackage from ad_module where ad_module.ad_module_id = tab.ad_module_id) as tab_module, tab.isactive, tab.name, tab.tablevel, tab.seqno from ad_window win, ad_tab tab, (select t.ad_window_id, t.tablevel, t.seqno, count(*) from ad_tab t group by t.ad_window_id, t.tablevel, t.seqno having count(*) >1 order by 1,2,3) input where win.ad_window_id=tab.ad_window_id and win.ad_window_id=input.ad_window_id and tab.tablevel = input.tablevel and tab.seqno = input.seqno order by win_module, win.ad_window_id, win.name, tab.tablevel, tab.seqno, tab.name;

Proposed SolutionCheck each case, select one tab and modifiy its seqno to no longer be conflicting
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045847 closed vmromanos Product | Price and Product customer share the same seqno and level 
blocks defect 0045473 new Triage Platform Base Add 2 more visible warnings for '>1 tabs on root-level of a window', check for '2 tabs has same seqno,tablevel' 
Attached Filestxt tabs-45818.txt (17,460) 2021-01-29 14:14
https://issues.openbravo.com/file_download.php?file_id=15290&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-01-29 14:08shuehnerNew Issue
2021-01-29 14:08shuehnerAssigned To => Triage Finance
2021-01-29 14:08shuehnerModules => Core
2021-01-29 14:08shuehnerTriggers an Emergency Pack => No
2021-01-29 14:08shuehnerRelationship addedblocks 0045473
2021-01-29 14:14shuehnerFile Added: tabs-45818.txt
2021-02-04 09:40vmromanosRelationship addedrelated to 0045847

There are no notes attached to this issue.