GoalMembership
To Create, Delete and Query memberships in the Goal.
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.
- GoalId supports the '=' comparison.
- MemberId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM GoalMembership SELECT * FROM GoalMembership WHERE Id = '1126938837961834' SELECT * FROM GoalMembership WHERE MemberId = '1126938837961830' SELECT * FROM GoalMembership WHERE GoalId = '1126938691750986'
Insert
GoalId and MemberId is a mandatory column for inserting into GoalMembership table. For example:
INSERT INTO GoalMembership (GoalId, MemberId) VALUES ('1161963899354167', '1126938837961830')
Delete
Following is an example of how to delete from GoalMembership table:
DELETE FROM GoalMembership WHERE Id = '1161963899354167'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique Id of the goal membership. | |
GoalId | String | False |
Goals.Id |
Globally unique identifier for goal. |
GoalName | String | True |
The name of the goal. | |
GoalOwnerGid | String | True |
Globally unique identifier of the goal owner. | |
GoalOwnerName | String | True |
The name of the goal owner. | |
Role | String | True |
Describes if the member is a commenter or editor in goal. | |
MemberId | String | False |
Globally unique identifier of the member of the goal. | |
MemberName | String | True |
The name of the member. | |
MemberResourceType | String | True |
The type of the member (team or user). | |
ResourceSubtype | String | True |
The type of membership. | |
ResourceType | String | True |
The base type of this resource. |