Returns organization memberships, 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 OrganizationMemberships WHERE Id = '123'

SELECT * FROM OrganizationMemberships WHERE UserId = '123'

SELECT * FROM OrganizationMemberships WHERE OrganizationId = '123'

Insert

You must specify the UserId and OrganizationId columns to perform an insert. This assigns a user to a given organization. This operation is allowed for logged-in users with the "agent" role.

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

Delete

You must specify the Id of the membership to delete it. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM OrganizationMemberships WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique Id automatically assigned when the membership is created.
OrganizationId	Long	False	Organizations.Id	The Id of the organization associated with this user in this membership.
UserId	Long	False	Users.Id	The Id of the user to whom this membership belongs.
Default	Boolean	False		Indicates whether this is the default organization membership for the user. If false, returns null.
CreatedAt	Datetime	False		The date and time when this record was created.
UpdatedAt	Datetime	False		The date and time when this record was last updated.
Url	String	False		The URL of this resource.