- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Bill,
Thanks. We must be working with different versions/databases because I don't have the tb_shared_users_2_queues table. Here is the query(not optimized) that I'm using for 8.2.1.
SELECT email from EDCPRINCIPALENTITY WHERE ID IN
(SELECT SHARED_QUEUES_ID FROM TB_57 WHERE OID IN
(SELECT OID FROM TB_57 WHERE SHARED_USERS_ID IN
(SELECT OID FROM TB_57 WHERE OID = SHARED_USERS_ID AND SHARED_QUEUES_ID =
(select ID FROM EDCPRINCIPALENTITY WHERE canonicalname = ?)))) AND canonicalname <> ?
Views
Replies
0 Likes
Total Likes