0022849: Filtering on identifier columns with multiple values is not precise enough

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022849

Openbravo ERP

A. Platform

public

2013-01-21 09:17

2013-01-21 09:18

Reporter

mtaal

Assigned To

AugustoMauch

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0022849: Filtering on identifier columns with multiple values is not precise enough

Description

Goto to the Matched Invoices window and filter on goods receipt line using the pull-down. Too many records are shown.

Steps To Reproduce

Goto to the Matched Invoices window and filter on goods receipt line using the pull-down. Too many records are shown.

Proposed Solution

The reason that this happens is in the AdvancedQueryBuilder, it is related to the handling of references/foreign keys to entities with multiple identifier fields. The filtering on such a reference is not precise.
It can also be related to how filtering works with quantity fields (the above example goods-receipt-line filter has numeric fields as part of the identifier).

See this line:
https://code.openbravo.com/erp/devel/pi/file/ff4be9f0d015/modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java#l551 [^]

Additional Information