Report filtering based on parameter is not working

Description

If there is report based on temporary table and there is an optional (non-mandatory) parameter for which you have data in table and column do exists in temporary however report engine doesnt filter by the parameter value.

Cause:
https://idempiere.atlassian.net/browse/IDEMPIERE-3992
In this feature, below is the condition causing the issue,

Here for any temporary table parameter will be skipped to be added to main query and hence report will not be filter by the optional parameter selected.

I believe we should do either of the following,

  • Remove isTemporaryTable flag at all from above condition and let the parameter get ignored for any table if column doesnt exists

  • Instead of || make it && so it would be applied to only temporary table (like it was before ) and skip if column not exists in temporary table

  • Change condition to below,

    •  


Last option would be same as first option

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Pritesh Shah

Labels

None

Tested By

None

Priority

Major
Configure