SalesOrderComments
Get the list of comments for a sales order.
View Specific Information
Select
The driver uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- SalesOrderId supports the '=' comparison.
The rest of the filter is executed client-side in the driver.
For example:
SELECT * FROM SalesOrderComments WHERE SalesOrderId = '460000000098765'
Columns
| Name | Type | References | SupportedOperators | Description |
| CommentId [KEY] | String | Id of the comment. | ||
| SalesOrderId | String |
SalesOrders.SalesorderId | Id of the sales order. | |
| Description | String | Description of the comment. | ||
| CommentedById | String | Id of the user who made the comment. | ||
| CommentedBy | String | Name of the user who made the comment. | ||
| CommentType | String | Type of the comment, either system-generated or user-added. | ||
| Date | Date | Date of the comment. | ||
| DateDescription | String | Relative description of the date, such as '4 days ago'. | ||
| Time | Time | Time of the comment. | ||
| OperationType | String | Type of operation performed, such as Added or Updated. | ||
| TransactionId | String | Id of the associated transaction. | ||
| TransactionType | String | Type of the associated transaction. |