Skip to main content
Solved

Custom field in Serial Object

  • September 10, 2021
  • 4 replies
  • 114 views

Forum|alt.badge.img+10

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

 

Best answer by Thushitha Chandrasiri

@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,

This topic has been closed for replies.

4 replies

Thushitha Chandrasiri
Superhero (Partner)
Forum|alt.badge.img+21

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.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • September 10, 2021

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

 


Thushitha Chandrasiri
Superhero (Partner)
Forum|alt.badge.img+21

@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,


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • September 10, 2021

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