Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014505Openbravo ERP00. Application dictionarypublic2010-09-09 16:482012-03-02 09:38
Reporterrafaroda 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS20OS VersionProfessional Appliance
Product Version2.50MP21 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014505: Read-only logic does not get properly columns stored in session
DescriptionRead-only logic does not get properly columns stored in session which results in a wrong behaviour in children tabs.
Steps To Reproduce1) 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 SolutionCan 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 [^]
Additional Information
Tagsdev-platform-quick-wins
Relationships
related to feature request 0011555 closed adrianromero Processed records should be rendered as read only 
related to defect 00142432.50MP23 closed sivaraman Requisition form is not following the logic of read only for completed status 
related to defect 00166713.0RC7 closed AinhoaPagola Date can be modified in a processed Internal Consuption 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-09 16:48rafarodaNew Issue
2010-09-09 16:48rafarodaAssigned To => alostale
2010-09-09 16:48rafarodaTag Attached: dev-platform-quick-wins
2010-09-13 08:08alostaleStatusnew => scheduled
2010-10-18 09:28rafarodaRelationship addedrelated to 0011555
2010-10-18 09:29rafarodaRelationship addedrelated to 0014243
2011-04-11 13:49AinhoaPagolaRelationship addedrelated to 0016671
2012-03-02 09:38alostaleNote Added: 0045689
2012-03-02 09:38alostaleStatusscheduled => closed
2012-03-02 09:38alostaleResolutionopen => out of date

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