0009083: Read Only Logic does not work if the clausure does not include a column from the table

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009083

Openbravo ERP

00. Application dictionary

public

2009-05-19 12:25

2009-05-21 00:00

Reporter

networkb

Assigned To

alostale

Priority

immediate

Severity

minor

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

2.40

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

0009083: Read Only Logic does not work if the clausure does not include a column from the table

Description

A read only logic does not work if the clausure is like:

@#AD_User_ID@!1000000

The javascript function created is:

function readOnlyLogic() {
readOnlyLogicElement('ColumnName', (strAD_User_ID != 1000000));
return true;
}

It seems that a field called strAD_User_ID should be a column from the table.
This column does not exist in the table so, the Read Only Logic does not work

Steps To Reproduce

Go to Application Dictionary > Tables and Columns > C_BPartner.

Search column: name.

In Read Only Logic add: @#AD_User_ID@!1000000

Compile the window.

Login the application using an user <> 1000000

Proposed Solution

It exists a workaround:

Create an Auxiliary input like:

@SQL=SELECT AD_USER_ID FROM AD_USER WHERE AD_USER_ID = @#AD_User_ID@

In Read Only logic use:

@AuxiliaryInputName@!1000000

Additional Information