Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0027138 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2014-07-21 12:34 | 2022-02-01 08:05 | ||||||
| Reporter | rafademiguel | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | pi | SCM revision | |||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0027138: Reference Table set as "Link to Parent Column" does not work. | ||||||||||
| Description | Using 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 Solution | As a workaround you can use the SQL/HQL WhereClause in the tab to filter the records properly | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0081665) alostale (manager) 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') |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-07-21 12:34 | rafademiguel | New Issue | |
| 2014-07-21 12:34 | rafademiguel | Assigned To | => alostale |
| 2014-07-21 12:34 | rafademiguel | Modules | => Core |
| 2014-07-21 12:34 | rafademiguel | Triggers an Emergency Pack | => No |
| 2015-03-17 14:38 | alostale | Assigned To | alostale => platform |
| 2015-11-10 16:47 | alostale | Note Added: 0081665 | |
| 2015-11-10 16:47 | alostale | Status | new => acknowledged |
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |