Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027138Openbravo ERPA. Platformpublic2014-07-21 12:342022-02-01 08:05
Reporterrafademiguel 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027138: Reference Table set as "Link to Parent Column" does not work.
DescriptionUsing a column that has reference "Table" and is set as "Link to Parent Column" does not apply the filter. You see all the records and not only the children records.
Steps To Reproduce- Create a column with Reference Table
- Use as "Link to Parent Column"
- Use the table in a sub tab linked to the parent
- Observe that in the sub tab you see all the records not only the children
Proposed SolutionAs a workaround you can use the SQL/HQL WhereClause in the tab to filter the records properly
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-21 12:34rafademiguelNew Issue
2014-07-21 12:34rafademiguelAssigned To => alostale
2014-07-21 12:34rafademiguelOBNetwork customer => No
2014-07-21 12:34rafademiguelModules => Core
2014-07-21 12:34rafademiguelTriggers an Emergency Pack => No
2015-03-17 14:38alostaleAssigned Toalostale => platform
2015-11-10 16:47alostaleNote Added: 0081665
2015-11-10 16:47alostaleStatusnew => acknowledged
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

Notes
(0081665)
alostale   
2015-11-10 16:47   
There are some cases in core:

select w.name, subtab.name, parenttab.name, c.columnname
from ad_column c, ad_tab subtab, ad_window w, ad_tab parenttab
where c.ad_reference_id = '18'
and c.isparent='Y'
and subtab.ad_table_id = c.ad_table_id
and subtab.tablevel > 0
and w.ad_window_id = subtab.ad_window_id
and parenttab.ad_tab_id = (select min(ad_tab_id)
                            from ad_tab t, ad_table tb
                            where t.ad_window_id = w.ad_window_id
                            and t.tablevel = subtab.tablevel-1
                            and t.seqno < subtab.seqno
                            and c.columnname ilike tb.tablename||'_id')