Returns organization subscriptions, including user and organization association details.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM OrganizationSubscriptions WHERE Id = '123'

SELECT * FROM OrganizationSubscriptions WHERE UserId = '123'

SELECT * FROM OrganizationSubscriptions WHERE OrganizationId = '123'

Insert

The UserId and OrganizationId columns are required to insert. Note that end users can only subscribe to shared organizations they belong to.

INSERT INTO OrganizationSubscriptions (UserId, OrganizationId) VALUES ('772', '881')

Delete

You must specify the Id of the subscription to delete it.

DELETE FROM OrganizationSubscriptions WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique Id automatically assigned to the organization subscription.
OrganizationId	Long	False	Organizations.Id	The Id of the organization associated with this subscription.
UserId	Long	False		The Id of the user associated with this subscription.
CreatedAt	Datetime	True		The date and time when this subscription was created.
Url	String	True		The URL of this resource.