Skip to main content

Hi there,

 

I want to create a Read Only Custom Field which refers to another Custom Field.

Only problem is that I keep getting Errors. 

Does anyone have a clue on how to resolve this?

This is tee Select Statement I used:

This is the Error that appears:

 

I've already looked at another topic on the community where a similar issue was presented. This however was an issue unresolved for APS9.  (see link below)

 

hi,

try “from customer_order_cfv”

hi

 

try from customer_order_cfv and  Arguments   v.Identity 

Hi guys,

 

I just tried your suggestions, but I still got an Error.

 

 

Are you sure you typed everything correctly?

This should work fine:

 

However when I define the Select Statement like this:

SELECT OBJECT FROM CUSTOMER_ORDER_CFV WHERE CUSTOMER_NO = :IDENTITY

(omitting the CF$_ prefix) then it will yield the exact same error as you reported.

 

By the way, I personally think it's nicer to create a public method for the original custom field on CustomerOrder

and then use that method as an Expression on the CustomerOrderInvHead

 

Thank you for the clear explanation ToBeNL, but I tried both suggestions and still get the same Error.

Could it be something else in the application?

Found the solution myself.

I came to the conclusion that the query was not right and I had another trial custom field in the same list. I believe that other one was generating the errors…

Terms & ConditionsCookie settings