ExpenseComments
Get the list of comments for an expense.
View Specific Information
Select
The driver uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- ExpenseId supports the '=' comparison.
The rest of the filter is executed client-side in the driver.
For example:
SELECT * FROM ExpenseComments WHERE ExpenseId = '460000000098765'
Columns
| Name | Type | References | SupportedOperators | Description |
| CommentId [KEY] | String | Id of the comment. | ||
| ExpenseId | String |
Expenses.ExpenseId | Id of the expense. | |
| 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. |