ReportComments
Read the comments entered on the expense report header, or the expenses of an existing expense report.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to ReportId, UserId, and ContextType. The connector processes other filters client-side within the connector.
All three filters are required to query ReportComments. If ReportId is not specified, the connector queries the Reports table to retrieve the Id values. If ContextType is not specified, the default value is TRAVELER.
The UserId value should be specified either in the query or in the UserId connection property. If CompanyLevelOAuth is active, all report comments for all users are pulled by default. This may result in a very large number of server requests.
Example queries:
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212'
SELECT * FROM ReportComments WHERE ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5')
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5')
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5') AND ContextType = 'PROXY'
Columns
| Name | Type | Description |
| Comment | String | The comments input on the report by all users. |
| AuthorFirstName | String | The comment author's first name. |
| AuthorLastName | String | The comment author's last name. |
| AuthorMiddleInitial | String | The comment author's middle initial. |
| CreationDate | Datetime | The UTC datetime when the comment was created on the report or expense. |
| ExpenseId | String | The unique identifier of the expense. |
| IsAuditorComment | Boolean | If true, this attribute represents whether this comment has been authored by an auditor. |
| IsLatest | Boolean | If true, this attribute represents the latest comment by the user. |
| StepInstanceId | String | The unique identifier of the step instance. |
| CreatedForEmployeeId | String | The unique identifier of the employee the comment was created on behalf of. |
| CreatedForEmployeeFirstName | String | The first name of the employee the comment was created on behalf of. |
| CreatedForEmployeeLastName | String | The last name of the employee the comment was created on behalf of. |
| CreatedForEmployeeMiddleInitial | String | The middle initial of the employee the comment was created on behalf of. |
| ReportId | String | The unique identifier of the report that is being read. |
| UserId | String | The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value. |
| ContextType | String | The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.
デフォルト値はTRAVELERです。 |
| IncludeAllComments | String | Return all the comments that are present on the report at all levels. Default value: true
デフォルト値はtrueです。 |