0023705: Not possible to select a value in drop down filter

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0023705

Openbravo ERP

A. Platform

public

2013-05-01 11:13

2013-05-07 15:43

Reporter

alostale

Assigned To

alostale

Priority

immediate

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP23

Fixed in Version

3.0MP23

Merge Request Status

Review Assigned To

shankarb

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - QA Approved

Regression date

2013-03-04

Regression introduced in release

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/f9728bac00aa8157efca54574bed21f0104d8e07 [^]

Triggers an Emergency Pack

Yes

Summary

0023705: Not possible to select a value in drop down filter

Description

Drop down combos in grid filter are not populated when they link to a table which identifier is composed by, at least, a reference to another table that is translatable.

In this case when opening the combo "No items to show" message is always shown. Though it is still possible to filter by typing in the text field.

A cast exception is shown in the backend log:

d05203b3 217738 [http-8880-4] ERROR org.openbravo.service.json.DefaultJsonDataService - org.openbravo.model.common.plm.Product cannot be cast to java.lang.String
java.lang.ClassCastException: org.openbravo.model.common.plm.Product cannot be cast to java.lang.String
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:121)
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:77)
    at org.openbravo.base.structure.BaseOBObject.getIdentifier(BaseOBObject.java:195)
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:124)
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:77)
    at org.openbravo.base.structure.BaseOBObject.getIdentifier(BaseOBObject.java:195)

Following query returns (some of) the columns, around 70, that might be affected by this issue:
select tablename, columnname
  from ad_table t1, ad_column c1
where t1.ad_table_id = c1.ad_table_id
  and c1.iskey = 'N'
  and c1.isparent ='N'
and
exists (
select 1
  from ad_table reft
  where c1.columnname ilike reft.tablename||'_id'
    and exists (select 1
                  from ad_column c
                  where c.ad_table_id = reft.ad_table_id
                  and c.isidentifier = 'Y'
                  and exists (select 1
                                 from ad_table trl
                                where tablename ilike substr(c.columnname,1,length(c.columnname)-3)||'_trl')))
  and exists (select 1
            from ad_field f, ad_tab tb
            where f.ad_tab_id = tb.ad_tab_id
            and f.isactive = 'Y' and tb.isactive='Y'
            and f.ad_column_id = c1.ad_column_id)
order by 1,2

Steps To Reproduce

-Open, for example, Good Transaction window
-Try to open Good Shipment Line drop down in filter -> Error occurs

Proposed Solution

The problematic line is in IdentifierProvider

value = ((BaseOBObject) dob).get(identifier.getName(), language, (String) dob.get("id"));

In the situation described, dob.get("id") is a BaseOBObject instead of a String.

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0022836	3.0MP21	closed	shankarb	In grid view, unit of measure filter is not translated when the translation pack is installed
related to	design defect	0023706		new	Triage Platform Base	Invalid BaseOBObject in drop down filter lists

Attached Files

Selection_163.png (17,914) 2013-05-01 11:19
https://issues.openbravo.com/file_download.php?file_id=6123&type=bug
png

Issue History

Date Modified

Username

Field

Change

2013-05-01 11:13