ContactListComments
List recent activities of a contact
Table Specific Information
Select
The add-in 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 add-in.
- 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 |