Question

How to send quick report output in email in IFS version 8

  • 3 January 2021
  • 3 replies
  • 442 views

Userlevel 5
Badge +9

Hello Community,

I need to send one quick report output to management as email at the morning 9 am.

Please help.


This topic has been closed for comments

3 replies

Userlevel 7
Badge +24

hi @Deepak 

in IFS Apps 8 you would need to use “scheduled PL/SQL” to run some logic, assemble a dataset and send it in an email body.

You can do this using code, if comfortable and you have access, or via Data Migration module.

The key command is Command_Sys.Mail() 

Userlevel 5
Badge +9

Thank you @paul harland for the guidance.

I will check and let you know if it works.

Userlevel 7
Badge +20

hi @Deepak 

in IFS Apps 8 you would need to use “scheduled PL/SQL” to run some logic, assemble a dataset and send it in an email body.

You can do this using code, if comfortable and you have access, or via Data Migration module.

The key command is Command_Sys.Mail() 

 

If you prefer coding method, may be Scheduled execution of a custom script | IFS Community could help to set up the scheduling part. I’d suggest to have the quick report SQL as a cursor and add it in the email body but there could be other ways to do it as well.

below thread explains how to add content in the email body as HTML.

Event Action condition setup | IFS Community

 

Hope it helps!

Damith