PortfolioItems
To Create, delete, and Query Items in the Portfolio.
Table Specific Information
Select
The add-in will use the Asana API to process WHERE clause conditions built with the following column and operator. The PortfolioId is required to make a request and rest of the filter is executed client side within the add-in.
- PortfolioId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PortfolioItems WHERE PortfolioId = '1173026173301164'
Insert
ProjectId and PortfolioId is a mandatory column for inserting into PortfolioItems table. For example:
INSERT INTO PortfolioItems (ProjectId, PortfolioId) VALUES ('1173023668354420', '1173026173301164')
Delete
Following is an example of how to delete from PortfolioItems table:
DELETE FROM PortfolioItems WHERE ProjectId = '1173023668354420' AND PortfolioId = '1173026173301164'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique ID of the Portfolio Item. | |
| Name | String | True |
Name of the Item. | |
| PortfolioId [KEY] | String | True |
Portfolios.Id |
Globally unique ID of the portfolio. |
| OwnerId | String | True |
Globally unique ID of the Owner. | |
| StartOn | Date | True |
The day on which work for this project begins, or null if the project has no start date. | |
| DueOn | Date | True |
The day on which this project is due. This takes a date with format YYYY-MM-DD. | |
| ProjectId | String | True |
Projects.Id |
Globally unique ID of the Project. This column is a Pseudocolmn and its used for INSERT and UPDATE. |