Skip to main content

Hi,

I have an existing Event based on the DOC_ISSUE_TAB table which triggers on ROWSTATE update. 

I need to add in the Custom Attribute to pull in the Title from the Document (not available on the DOC_ISSUE_TAB) but can’t seem to get the function to operate without error. 

Has anyone completed this previously and could advise?

 

 

Hi @PORBBAKER,

Are you getting an error when saving it?
I think you need to pass in the variable values using the : colon)

Example:
edm_file_api.get_file_name(:old.doc_class,:old.doc_no,:old.doc_sheet,:old.doc_rev,'ORIGINAL',1)

Best Regards,
Bhagya

Hi @PORBBAKER,

Are you getting an error when saving it?
I think you need to pass in the variable values using the : colon)

Example:
edm_file_api.get_file_name(:old.doc_class,:old.doc_no,:old.doc_sheet,:old.doc_rev,'ORIGINAL',1)

Best Regards,
Bhagya

Hi Bhagya,

Apologies, probably wasn’t clear in the Original post, the FILENAME custom Attribute is working correctly, it is the new attribute I need assistance on to pull in the DOC_TITLE.

Thanks

Ben

Hello @PORBBAKER 

Reading your post and seeing your screenshot.

Sounds like you are looking for a function that can return the document title. 

If I am understanding your question correctly. I searched in the DOC_ISSUE_API and I do not see any function to return the title, I am using IFS 9. However, you could build a custom function to return the title.

You can use the parameters below:

FUNCTION Get_Document_Title (
   doc_class_ IN VARCHAR2,
   doc_no_    IN VARCHAR2,
   doc_sheet_ IN VARCHAR2,
   doc_rev_   IN VARCHAR2 ) RETURN VARCHAR2

and you can call the function from your custom event. Do not forget to refresh dictionary cache before.

 

I hope this help :-)

 

Thanks,

JL

 

 

Reply


Terms & ConditionsCookie settings