Hi Bentley and the Forum,
Is it possible to create an eQL report (or SQL) to show the subscriptions (the users who have subscribed) to document/s at all? I have looked in the eQL guide and what objects we can do the eQL on and it doesn't look like I can
Many thanks,
Julie
Hi Julie,
In SQL Database you can see these details in the following tables 'subscribers' and 'subscriptions'.
Or you can use the below SQL Query :
Select S.subscriber_id, S.object_id, S.object_type, S.delivery_field1, P.object_id, P.object_type, P.subscription_idFrom subscribers S Inner JOIN subscriptions PON S.subscriber_id = subscription_id
Regards,
Sayyad
Answer Verified By: julie_beck
Thank you Sayyad!