0018835: Validation rules on process' parameters can only use real columns

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0018835

Openbravo ERP

A. Platform

public

2011-10-21 15:15

2022-02-01 08:08

Reporter

gorkaion

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

new

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

0018835: Validation rules on process' parameters can only use real columns

Description

When using a validation rule to filter a dropdown on a parameter of a process. Only physical columns of the table where is the button that launches the process can be used.

It should also consider "Auxiliar Inputs".

Steps To Reproduce

N/A

Proposed Solution

The selectComboParams() query of ActionButtonRelation_Data.xsql should also check if exists an auxiliar input on the tab with the same value.

(exists (select 1
         from ad_column c1, ad_field f
         where t.ad_table_id = c1.ad_table_id
           and upper(c1.columnname)=upper(substr(code, instr(code,'@')+1, instr(code,'@',1,2)-instr(code,'@')-1))
           and f.ad_column_id = c1.ad_column_id)
or exists (select 1
           from ad_auxiliarinput ai
           where ai.ad_tab_id = tb.ad_tab_id
             and upper(ai.name) = upper(substr(code, instr(code,'@')+1, instr(code,'@',1,2)-instr(code,'@')-1)))

Additional Information