0009098: 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

0009098

Openbravo ERP

00. Application dictionary

public

2009-05-20 08:33

2009-05-22 19:26

Reporter

alostale

Assigned To

iciordia

Priority

none

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

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

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

Description

Read only logic only works when the values included within it are columns for the same table than the field that affect it.

It would be necessary to add the capability of adding session values too.

For example a read only logic does not work if the clause 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

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

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

Additional Information