ODBC Driver for Pipedrive

Build 24.0.9062

DealsSummary

Return detils of deals summary.

Select

The 本製品 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 本製品.

  • 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 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.
EURCount Integer EUR Count.
EURValue Integer EUR Value.
EURConverted Double EUR Converted.
EURConvertedFormatted String EUR Converted Formatted.
EURFormatted String EUR Formatted.
USDCount Integer USD Count.
USDValue Integer USD Value.
USDConverted Integer USD Converted.
USDConvertedFormatted String USD Converted Formatted.
USDFormatted String USD Formatted.
WeightedEURCount Integer Weighted EUR Count.
WeightedEURValue Integer Weighted EUR Value.
WeightedEURValueFormatted String Weighted EUR Value Formatted.
WeightedUSDCount Integer Weighted USD Count.
WeightedUSD Integer Weighted USD.
WeightedUSDFormatted String Weighted USD Formatted.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FilterId Integer Filter Id.
UserId Integer User Id.
StageId Integer Stage Id.
Status String Status.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062