0014505: Read-only logic does not get properly columns stored in session

Description

Read-only logic does not get properly columns stored in session which results in a wrong behaviour in children tabs.

Steps To Reproduce

1) Logged as System Administrator, navigate to Application Dictionary || Tables and Columns || Table and select table Project
2) Go to Column Projectstatus and set it as Stored in Session
3) Go to Table Project Line
4) Go to Column Product and set read-only logic: @Projectstatus@='OP'

Compile project windows: ant compile.development -Dtab="project"

Restart Tomcat

Navigate to Service Project Lines of a project with Status = Open: see that Product field is editable (non read-only).

Proposed Solution

Can be workarounded with auxiliary inputs [1]

See: SELECT * FROM AD_AUXILIARINPUT WHERE UPPER(CODE) LIKE '%SQL%PROCESSED%'

And:
SELECT t.name AS table_name, c.name AS column_name, c.readonlylogic AS read_only_logic
FROM ad_table t, ad_column c
WHERE c.readonlylogic IS NOT NULL
AND c.ad_table_id = t.ad_table_id
AND UPPER(c.readonlylogic) LIKE '%PROCESSED%'
ORDER BY t.name, c.name;

[1] http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Concepts/AD/Dynamic_Expressions#Auxiliary_inputs [^]

Tags

dev-platform-quick-wins

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	feature request	0011555		closed	adrianromero	Processed records should be rendered as read only
related to	defect	0014243	2.50MP23	closed	sivaraman	Requisition form is not following the logic of read only for completed status
related to	defect	0016671	3.0RC7	closed	AinhoaPagola	Date can be modified in a processed Internal Consuption

Notes
(0045689) alostale (manager) 2012-03-02 09:38	Working fine in OB3

Issue History
Date Modified	Username	Field	Change
2010-09-09 16:48	rafaroda	New Issue
2010-09-09 16:48	rafaroda	Assigned To	=> alostale
2010-09-09 16:48	rafaroda	Tag Attached: dev-platform-quick-wins
2010-09-13 08:08	alostale	Status	new => scheduled
2010-10-18 09:28	rafaroda	Relationship added	related to 0011555
2010-10-18 09:29	rafaroda	Relationship added	related to 0014243
2011-04-11 13:49	AinhoaPagola	Relationship added	related to 0016671
2012-03-02 09:38	alostale	Note Added: 0045689
2012-03-02 09:38	alostale	Status	scheduled => closed
2012-03-02 09:38	alostale	Resolution	open => out of date