Skip to main content
10-Marble
Aug 18, 2023 1:46 PM UTC
Solved

How to send email with a QML report that consists list of pending ECN/ECR?

I have a QML report that lists all ECNs that are in 'Implementation' State and who it is assigned to. 

Question: Is it possible to run a scheduler, that triggers every Monday, generates this QML report and sends an EMAIL to whoever the ECNs are assigned to?

 

 

MarcoTosin
21-Topaz II
Aug 18, 2023 2:03 PM UTC

You have to use data monitor.

Take a look at this article How to execute the data monitor report at the specified time

 

Marco

2 replies

MarcoTosin
21-Topaz II
Aug 18, 2023 2:03 PM UTC

You have to use data monitor.

Take a look at this article How to execute the data monitor report at the specified time

 

Translate
Marco
14-Alexandrite
Aug 18, 2023 2:27 PM UTC

@Marco_Tosin is right about the data monitor capability for scheduling a query builder report to run at a scheduled time and email the results, however the email recipients is only a set list, not generated based on the contents of the report result.  I've had similar use-cases pop up and the only solution I can think of is to have the email route a dummy inbox that can be captured by something like MS-PowerAutomate which can then parse the report results and email the individuals.  I've never had time to implement it.... but that's my though as a workaround that doesn't rely on custom Windchill development.

Translate