I have a timer script that sends out an email each week and includes a run time report from an sql query and attaches a file to the email, the recipient addresses are currently being pulled from some tags where I have stored their email addresses.
I have 2 questions;
#1 rather than have the recipients stored in tags how can I pull contact info from ignition users where they belong to a particular role - for example im looking for something like:
“system.users.get contact info(email address) where role = (supervisor)”
#2 is this weekly email notification im scripting something that is also possible using the notification block? ie. being able to send the notification every Sunday at midnight and include various sql queries and include attachments?