0018834: Columns used on validation rules of process parameters are not correctly calculated

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0018834

Openbravo ERP

A. Platform

public

2011-10-21 15:09

2022-02-01 08:08

Reporter

gorkaion

Assigned To

Triage Platform Base

Priority

normal

Severity

major

Reproducibility

always

Status

acknowledged

Resolution

open

Platform

OS Version

Gentoo

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

0018834: Columns used on validation rules of process parameters are not correctly calculated

Description

It is not possible to use a validation rule that uses more than one column to filter the drop down in a process' parameter.

Consider a process called from a window that has a parameter filtered using a validation rule. If this validation rule uses more than one column to filter only the first one is used.

Steps To Reproduce

1. Go to the 'Payment In' window and remove the filter to get one that it is processed. Click on the 'Reactivate' button and check that 'Reactivate' and 'Void' actions are available.

2. Change to System Admin role and go to the ''Process Payment valid actions'' validation setup that it is used to filter the available actions to process a payment.

Change the code from:

((@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR (@EM_APRM_Process_Payment@ = 'R' AND AD_Ref_List.value IN ('R', 'V')) OR (@EM_APRM_Process_Payment@ is null))

to:

(@isActive@ = @isActive@ AND (@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR (@EM_APRM_Process_Payment@ = 'R' AND AD_Ref_List.value IN ('R', 'V')) OR (@EM_APRM_Process_Payment@ is null))

3. Compile the window using 'ant compile -Dtab="Payment In"'

4. Refresh tomcat and go again to the same payment and click the 'Reactivate' button. Check that the available actions have been changed although the validation should return the same values.

5. Check that the org.openbravo.erpWindows.PaymentIn.Header class is only setting the isActive value and not setting the 'EM_APRM_Process_Payment' field's value.

Proposed Solution

The issue is on the getComboParaCode() method of WadActionButton class.

The selectComboParams() query is parsing the code of the validation rule and getting the first value it finds between "@".

Additional Information