Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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>

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools