Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to get the list of all recipient users (Users present in To section and also cc/bcc section of mail) for all publish tasks.
I searched around and found two ways mentioned in net, one to use API and another to connect to postgreSQL repository database mentioned here (https://community.qlik.com/t5/Qlik-NPrinting/Overview-Users-per-task-in-NPrinting/td-p/1704918)
I tried the second approach and queried the "public"."publish_report_task_recipient" table which contains recipient details. But I see most tasks only have the recipients under TO section in the mail. They dont have recipients in the CC/BCC section in the mail.
Please let me know if there is any other way or if I'm doing something wrong.
These tables should get the info you need with these two field smtp_destination_id and email:
public"."smtp_destination_to_to"
"public"."smtp_destination_to_cc"
"public"."smtp_destination_to_bcc"
You can join these to "public"."destination" table with the id field which will also list the TaskIDs in the publish_report_task_id field.
EX:
These tables should get the info you need with these two field smtp_destination_id and email:
public"."smtp_destination_to_to"
"public"."smtp_destination_to_cc"
"public"."smtp_destination_to_bcc"
You can join these to "public"."destination" table with the id field which will also list the TaskIDs in the publish_report_task_id field.
EX:
Worked like a charm!!! Thanks @TheLazyDeveloper !!!