Solved

Custom field in Serial Object

  • 10 September 2021
  • 4 replies
  • 53 views

Userlevel 3
Badge +4

Hi,  I want to add acustom field on the serial object that holds the Support Agreement ID from the support agreement but I am getting the following error message:

Creation of custom field

 

Error message
Serial Object
Support agreement

 

icon

Best answer by ThushAsanka 10 September 2021, 11:57

View original

4 replies

Userlevel 7
Badge +13

Hi @JannetteC ,

Based on the requirement, I think your select statement should be like below.

select agreement_id from ifsapp.cc_support_agreement where customer_id = :owner

And the  arguments should be;

v.owner

Try these and see whether it works.

Userlevel 3
Badge +4

Hi @ThushAsanka , I have tried that but I am getting the same error message.

 

Userlevel 7
Badge +13

@JannetteC, just checked, and noticed that it’s not agreement_id, and it’s support_agreement_id.

So, it should be like below.

select support_agreement_id from ifsapp.cc_support_agreement where customer_id = :owner

 

Thanks,

Userlevel 3
Badge +4

Thanks @ThushAsanka I was missing the = sign, all good now.

Reply