Skip to main content
Question

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

  • January 3, 2021
  • 3 replies
  • 538 views

Deepak
Sidekick
Forum|alt.badge.img+10

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 replies.

3 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+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() 


Deepak
Sidekick
Forum|alt.badge.img+10
  • Author
  • Sidekick
  • January 8, 2021

Thank you @paul harland for the guidance.

I will check and let you know if it works.


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • January 8, 2021

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