OpportunityCount
Generates a summary of the total number of opportunities within a stage.
Table Specific Information
Select
The 本製品 will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.
- Date supports the '=,>,<,>=,<=' operators.
- DateType supports the '=' operator.
- ValueType supports the '=' operator.
- ProbabilityValue supports the '=' operator.
- ProbabilityOperation supports the '=' operator.
- AmountValue supports the '=' operator.
- AmountOperation supports the '=' operator.
- OmitPrivate supports the '=' operator.
- TypeId supports the '=' operator.
- UserId supports the '=' operator.
- StageId supports the '=' operator.
- PickListItemId supports the '=' operator.
- Status supports the '=' operator.
The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server side:
SELECT * FROM OpportunityCount where Date = '2023-03-12' SELECT * FROM OpportunityCount
Columns
Name | Type | Description |
Count | Integer | Count |
Ordinal | Integer | Ordinal |
StageId | String | Stage Id |
StageName | String | Stage Name |
Value | Integer | Value |
StartTime | Datetime | Start Time |
EndTime | Datetime | End Time |
DateType | Integer | Date Type |
ValueType | Integer | Value Type |
ProbabilityValue | Integer | Probability |
ProbabilityOperation | String | Probability Operation |
AmountValue | Decimal | Amount Value |
AmountOperation | String | Amount Operation |
OmitPrivate | Boolean | Omit Private |
TypeId | String | Type Id |
UserId | String | User Id |
StageId | String | Stage Id |
PickListItemId | String | Pick List Item Id |
Status | String | Status |