eQL to download a full list of the Subscriptions


	Applies To

	Product(s):	eB Web
	Version(s):
	Environment:	N/A
	Area:
	Subarea:
	Original Author:	Padma Kanadi, Bentley Technical Support Group

Problem:

User needs an eQL to download a full list of the Subscriptions, where the subscriptions have been assigned.

Solution:

The below eQL will help resolve users issue:

START WITH Document
SELECT
   Id,
   Code Number,
   Revision,
   State,
   DISPLAY_NAME(ApprovalStatus) Status,
   Attributes["CAS", "CAS Department"].Value Department,
   Subscriptions.Subscriber.Object.Id SubscriberId,
   Subscriptions.Subscriber.Object.Label Subscriber,
   Subscriptions.Subscriber.DeliveryAddress Email
WHERE
   IsTemplate = 'N'
   AND Subscriptions.Subscriber.Object.Id IS NOT NULL

Created by Padma Kanadi
When: Wed, Mar 30 2022 8:35 AM
Revisions: 1
Comments: 0

Recommended