WorkspaceMembership
To Create, Delete and Query memberships in the Workspace.
Table Specific Information
Select
The 本製品 will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- Id supports the '=' comparison.
- UserId supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkspaceMembership WHERE WorkspaceId = '1126938837961830' SELECT * FROM WorkspaceMembership WHERE UserId = '1126938691750986' SELECT * FROM WorkspaceMembership WHERE Id = '1126938837961834'
Insert
UserId and WorkspaceId is a mandatory column for inserting into WorkspaceMembership table. For example:
INSERT INTO WorkspaceMembership (UserId, WorkspaceId) VALUES ('1161963899354167', '1126938837961830')
Delete
Following is an example of how to delete from WorkspaceMembership table:
DELETE FROM WorkspaceMembership WHERE UserId = '1161963899354167' AND WorkspaceId = '1126938837961830'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique ID of the membership. | |
userId [KEY] | String | True |
Users.Id |
Globally unique ID of the user. |
userName | String | True |
The user`s name. | |
WorkspaceId [KEY] | String | True |
Workspaces.Id |
Globally unique ID of the workspace. |
WorkspaceName | String | True |
The Workspace name. | |
IsActive | Boolean | True |
Reflects if this user still a member of the workspace. | |
IsAdmin | Boolean | True |
Reflects if this user is an admin of the workspace. | |
IsGuest | Boolean | True |
Reflects if this user is a guest of the workspace. | |
UserTaskListId | String | True |
UserTaskList.Id |
A user task list represents the tasks assigned to a particular user. |
ResourceType | String | True |
The base type of this resource. | |
VacationStartDate | String | True |
The day on which the user's vacation in this workspace starts. | |
VacationEndDate | String | True |
The day on which the user's vacation in this workspace ends. |