ContactListComments
List recent activities of a contact
Table Specific Information
Select
The connector will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- ContactId supports the '=' comparison.
- CommentId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ContactListComments WHERE ContactId = '3350895000000089001' SELECT * FROM ContactListComments WHERE CommentId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| CommentId [KEY] | Long | The unique id of each comment associated with a contact | |
| CommentedBy | String | The name of the person who has commented | |
| CommentedById | Long | The unique id generated for the person who has commented | |
| ContactId | Long |
Contacts.Id | The unique id generated by the contact server |
| ContactName | String | The name of the contact | |
| Date | Date | Date when the comment was made | |
| DateDescription | String | Days passed from the day when comment was made | |
| Description | String | Description | |
| IsEntityDeleted | Boolean | A boolean value which will be true if the comment will be deleted. | |
| OperationType | String | Type of Operation | |
| Time | Datetime | Time when te comment was made | |
| TransactionId | Long | Id for the transaction | |
| TransactionType | String | Type of transaction |