Represents the group memberships that define which agents belong to which groups.

Table-Specific Information

Select

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

SELECT * FROM GroupMemberships WHERE Id = '123'

SELECT * FROM GroupMemberships WHERE UserId = '123'

SELECT * FROM GroupMemberships WHERE GroupId = '123'

Insert

The UserId and GroupId columns are required to insert. This assigns an agent to a given group. This operation is allowed for logged-in users with the "admin" role only.

INSERT INTO GroupMemberships (UserId, GroupId) VALUES ('72', '88')

Delete

You must specify the Id of the membership to delete it. This immediately removes a user from a group and schedules a job to unassign all working tickets that are assigned to the given user and group combination. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM GroupMemberships WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id of the group membership, automatically assigned when it is created.
UserId	Long	False	Users.Id	The Id of the agent.
GroupId	Long	False	Groups.Id	The Id of the group.
Default	Boolean	False		Indicates whether tickets assigned directly to the agent use this membership's group.
CreatedAt	Datetime	True		The date and time when the membership was created.
UpdatedAt	Datetime	True		The date and time when the membership was last updated.
Url	String	True		The API URL of this record.