0024836: Filter columns in query/list widgets - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0024836

Openbravo ERP

A. Platform

public

2013-09-26 17:35

2013-10-18 12:30

Reporter

caristu

Assigned To

shankarb

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP29

Fixed in Version

3.0MP29

Merge Request Status

Review Assigned To

AugustoMauch

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

0024836: Filter columns in query/list widgets

Description

Filter columns is not working in query/list widgets if the @optional_filters@ clause is not present. This can lead the user to think that the filters for widgets are not working properly, because the "Can be filtered" checkbox are already marked.

Steps To Reproduce

As system admin:
1) Create a Query/List widget of HQL type, using the following clause in the [Query tab]:
select p.searchKey as value,
p.name as nombre
from Product p
2) Create two registers in the [Column] tab for both columns: value and name. Use the string reference and mark the "Can be filtered" checkbox for both.
3) In the Where Clause Left Part put p.searchKey and p.name respectively

As group admin
4) Go to the [Role] window and in the [Widget Access Tab] give permissions to the group admin role for the new widget
5) Add the widget to the workspace. Notice that the filters are not working.

Proposed Solution

The @optional_filters@ clause must be used in order to make the filters work. It would be nice to warn the user if the "Can be filtered" checkbox is marked for a widget column and the @optional_filters@ is not present in the query.

Additional Information