ReportComments
Read the comments entered on the expense report header, or expenses of an existing expense report.
Table Specific Information
Select
The adapter uses the SAP Concur APIs to process filters that refer to ReportId, UserId, and ContextType. The adapter processes other filters client-side within the adapter.
All 3 filters are required to query ReportComments. If ReportId is not specified, the adapter will query the Reports table to retrieve the Id values. If ContextType is not specified, the default value will be TRAVELER. The UserId value should either be specified in the query or in the UserId connection property.
These are some example queries:
SELECT * FROM ReportComments SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' 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 | References | 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
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. |