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)))

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

design defect

0018834

acknowledged

Triage Platform Base

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

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2011-10-21 15:15	gorkaion	New Issue
2011-10-21 15:15	gorkaion	Assigned To	=> alostale
2011-10-21 15:15	gorkaion	Modules	=> Core
2011-10-21 15:15	gorkaion	OBNetwork customer	=> No
2011-10-21 15:15	gorkaion	Relationship added	related to 0018834
2017-04-10 14:38	alostale	Assigned To	alostale => platform
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base