Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0045818Openbravo ERP00. Application dictionarypublic2021-01-29 14:082021-01-29 14:14
shuehner 
Triage Finance 
normalminorhave not tried
newopen 
5
 
 
Core
No
0045818: Tracking issue: Modules adding tabs with same tablevel & seqno as an existing tab should be fixed
Having 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.
List 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;

Check each case, select one tab and modifiy its seqno to no longer be conflicting
No tags attached.
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' 
txt tabs-45818.txt (17,460) 2021-01-29 14:14
https://issues.openbravo.com/file_download.php?file_id=15290&type=bug
Issue History
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.