Differences

This shows you the differences between two versions of the page.

--- onboarding:digportal:dig_ticket_creation_activity_check [2017/12/19 11:49] – created mmcc
+++ onboarding:digportal:dig_ticket_creation_activity_check [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Dig Ticket Creation Activity Check ======
+<code>Example email subject: Ticketer - Ticket Count Alert for 'CBYD - Chicago'
+See SUPPORT-299 - CBYD - Arizona North and CBYD - Arizona South are test markets as identified by CC</code>
+Query to find distribution for current checks related to CBYD markets:
+<code>
+SELECT
+    v.id, v.name,  GROUP_CONCAT(u.email_address)
+FROM
+    ticket_creation_activity_check c
+        JOIN
+    visibility v ON v.id = c.visibility_id
+        LEFT JOIN
+    ticket_creation_activity_check_user cu ON cu.ticket_creation_activity_check_users_to_notify_of_breach_id = c.id
+        LEFT JOIN
+    user u ON u.id = cu.user_id
+GROUP BY v.name;
+</code>
+In order to add a distribution to one of these entries these tables link together as below:
+<code>
+SELECT * FROM
+ticketer.ticket_creation_activity_check_user tcacu
+JOIN user u on u.id = tcacu.user_id
+JOIN ticket_creation_activity_check tcac ON tcac.id = tcacu.ticket_creation_activity_check_users_to_notify_of_breach_id;
+</code>
+Insert query example:
+<code>
+INSERT INTO ticket_creation_activity_check_user (ticket_creation_activity_check_users_to_notify_of_breach_id, user_id) VALUES(14, 115);
+</code>

Internal Errigal Collaboration Wiki