It looks like you are trying to fetch contract_name from SALES_CONTRACT view. Since you are passing contract_name as an argument to the SELECT statement, you need to have that as an attribute in your Customer LU.
I think what you should have is something like contract_no in your Custom LU, so that you can fetch the contract_name for that contract_no. Could you also show what other attributes you have in the LU?
Have a look at the documentation for Read Only fields as well:
Is there an attribute named “contract_name” in your custom LU? Is it approved and publised? Please send the configuration of the contract_name and the definition of the newly created attribute.
I do not have much experience with the Custom Logical Unit page so forgive me if I’m going in the wrong direction.
Please see below the SQL statement/ argument used:
For a bit of clarification - I am trying to pull the Contract Name from the header of our Sales Contract page we have into an attribute for this Custom Logical Unit which is a tab on the Sales Contract page as a fixed item that cannot be altered.
I had originally tried to set up this attribute as a “persistent” field type, but it was not pulling through once I approved and published it.
It looks like you are trying to fetch contract_name from SALES_CONTRACT view. Since you are passing contract_name as an argument to the SELECT statement, you need to have that as an attribute in your Customer LU.
I think what you should have is something like contract_no in your Custom LU, so that you can fetch the contract_name for that contract_no. Could you also show what other attributes you have in the LU?
Have a look at the documentation for Read Only fields as well:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.