CloseReason
Generates opportunity data to summerizes how many times a reason has been closed.
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.
- Status supports the '=' operator.
The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server side:
SELECT * FROM CloseReason where Status = 'open'
Columns
| Name | Type | Description |
| Count | Integer | |
| Reason | String | |
| Status | String | Status of Activities
使用できる値は次のとおりです。open, won, lost, inactive |
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 |
| Date | Datetime | Date Range of Activities By User |