Search code examples
logicreadonlyadempiere

Make a column read only in adempiere

I have two columns called "C_BPartner_ID" and "displayname" in my table. I want to make read only "displayname" column when "C_BPartner.name"='test'

The problem is I do not know how to make read only this field in adempiere. I added following sql query into readonly logic field in table & column.

@SQL=(SELECT C_BPartner.C_BPartner_ID  FROM C_BPartner WHERE C_BPartner.name='test')=@C_BPartner_ID@

I think using "Column SQL" we can make field read only. I tried out to do that also.. But it also didn't work for me.

This is not working..... Can anybody please help me... thanks..

Solution

  • Inner join doesnt work, Lets do one thing add C_BPartner_ID.Name (like hiddenfield) in your table and try to use it