Question

Custom Event Email db Value

  • 10 March 2022
  • 3 replies
  • 122 views

Userlevel 2
Badge +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

Userlevel 2
Badge +6

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)

 

 

Userlevel 5
Badge +13

HI @matthunter,

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

Best Regards,
Bhagya

Userlevel 2
Badge +6

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