Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0045818
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 00. Application dictionaryminorhave not tried2021-01-29 14:082021-01-29 14:14
ReportershuehnerView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045818: 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
TagsNo tags attached.
Attached Filestxt file icon tabs-45818.txt [^] (17,460 bytes) 2021-01-29 14:14 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0045847 closedvmromanos Product | Price and Product customer share the same seqno and level 
blocks defect 0045473 newTriage Platform Base Add 2 more visible warnings for '>1 tabs on root-level of a window', check for '2 tabs has same seqno,tablevel' 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-01-29 14:08 shuehner New Issue
2021-01-29 14:08 shuehner Assigned To => Triage Finance
2021-01-29 14:08 shuehner Modules => Core
2021-01-29 14:08 shuehner Triggers an Emergency Pack => No
2021-01-29 14:08 shuehner Relationship added blocks 0045473
2021-01-29 14:14 shuehner File Added: tabs-45818.txt
2021-02-04 09:40 vmromanos Relationship added related to 0045847

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker