SalesByRepDetails
Generates opportunity sales by user data for a given user.
Table Specific Information
Select
The adapter will use the ActCRM API to process WHERE clause conditions built with the following column and operator. UserID is required to make a request and the rest of the filter is executed client-side within the adapter
- Date supports the '=,>,<,>=,<=' operators.
- UserId supports the '=' operator.
The adapter processes other filters client-side within the adapter. For example, the following queries are processed server side:
SELECT * FROM SalesByRepDetails where UserId = 'b7c23fa5-6cd3-4bcd-a036-f8bbb85ba760'
Columns
| Name | Type | Description |
| ClosedDate | Datetime | Close Date |
| OppName | String | Opp Name |
| OppValue | Integer | Opp Value |
| RepName | String | Rep Name |
| UserId | String | User Id |
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 |