Solved

Read Only Custom Field using another Custom Field (APS10)

  • 4 January 2021
  • 6 replies
  • 571 views

Badge +6

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)

 

icon

Best answer by bnzKarin 5 January 2021, 15:21

View original

This topic has been closed for comments

6 replies

Userlevel 7
Badge +24

hi,

try “from customer_order_cfv”

Userlevel 5
Badge +8

hi

 

try from customer_order_cfv and  Arguments   v.Identity 

Badge +6

Hi guys,

 

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

 

 

Userlevel 5
Badge +14

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

 

Badge +6

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?

Badge +6

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…