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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

feature request

0009098

new

iciordia

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

Notes
(0016462) rafaroda (viewer) 2009-05-19 12:28	Asier, Could you please determine whether this is a defect or not? Thanks.

(0016481) alostale (viewer) 2009-05-20 08:35	A feature request (0009098) has been created from this issue. This issue is not going to be fixed as it has a simple workaround (described above).

Issue History
Date Modified	Username	Field	Change
2009-05-19 12:25	networkb	New Issue
2009-05-19 12:25	networkb	Assigned To	=> rafaroda
2009-05-19 12:25	networkb	OBNetwork customer	=> Yes
2009-05-19 12:25	networkb	Regression testing	=> No
2009-05-19 12:27	rafaroda	Assigned To	rafaroda => alostale
2009-05-19 12:28	rafaroda	Note Added: 0016462
2009-05-20 08:33	alostale	Issue cloned	0009098
2009-05-20 08:33	alostale	Relationship added	related to 0009098
2009-05-20 08:35	alostale	Status	new => closed
2009-05-20 08:35	alostale	Note Added: 0016481
2009-05-20 08:35	alostale	Resolution	open => no change required
2009-05-21 00:00	anonymous	sf_bug_id	0 => 2794609