Pipeline
Gets all opportunity matching the custom filter that are currently being worked.
Table Specific Information
Select
The component 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 component processes other filters client-side within the component. For example, the following queries are processed server side:
SELECT * FROM Pipeline
Columns
Name | Type | Description |
Id [KEY] | String | |
CompanyName | String | Company Name |
ContactCount | Integer | Contact Count |
ContactName | String | Contact Name |
EstCloseDate | Datetime | Est Close Date |
Name | String | Name |
ProbabilityPct | Integer | Probability Pct |
StageId | String | Stage Id |
StageName | String | Stage Name |
TotalValue | Integer | Total Value |
WeightedValue | Integer | Weighted 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 |