DealsSummary
Return detils of deals summary.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Status supports the '=' operator.
- UserId supports the '=' operator.
- FilterId supports the '=' operator.
- StageId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM DealsSummary WHERE UserId = 8230170 SELECT * FROM DealsSummary WHERE Status = 'open' SELECT * FROM DealsSummary WHERE StageId = 1 SELECT * FROM DealsSummary WHERE FilterId = 1
Columns
| Name | Type | References | Description |
| TotalCount | Integer | Total Count. | |
| Totalvalue | Double | Total value. | |
| TotalValueFormatted | String | Total Value Formatted. | |
| TotalWeightedValue | Double | Total Weighted Value. | |
| TotalWeightedValueFormatted | String | Total Weighted Value Formatted. | |
| ValuesTotal | String | Values total | |
| WeightedValuesTotal | String | Weighted values total |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| FilterId | Integer | Filter Id. | |
| UserId | Integer | User Id. | |
| StageId | Integer | Stage Id. | |
| Status | String | Status. |