Skip to main content
Question

Custom Event Email db Value


Forum|alt.badge.img+6

Hello IFS community,

I’m having an issue when I trigger an auto-email event where a custom attribute is referenced which (in this case) a Part Number called CF$_PART_NO

The field is a Persistent > Reference (Restricted) > Reference below

Upon creation of new object I would like to call upon the Part_No chosen in the email.

I use the substitution field &NEW:CF$_PART_NO

However in the generated email I get the db value AAAVZCAAMAAACXrAAH

My assumption is that there is an API that will convert that value from the db to it’s key, but when I try to do INVENTORY_PART_API.get_key_by_rowkey(&NEW:CF$_PART_NO) I get this error message in the Custom Event screen:

Then the event doesn’t trigger unless this is resolved. I feel like this is the right method, but perhaps I’m missing a key ingredient?

 

Thanks for whoever helps!

IFS9 btw

This topic has been closed for comments

3 replies

Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 11 replies
  • March 10, 2022

And to add to my own post, I’ve tried to use the custom API with the custom logical unit, but I get this error when trying to save the entry:

PL/SQL:

S_P_N_REQUEST_CLP.Get_Cf$_Part_No(&NEW:ROWKEY)

 

 


Forum|alt.badge.img+13

HI @matthunter,

Can you please share the screen shots of your event and the action defined?

Best Regards,
Bhagya


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 11 replies
  • March 14, 2022

I removed the email address but here’s what I have for this event

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings