ReportComments
Read the comments entered on the expense report header, or expenses of an existing expense report.
Table Specific Information
Select
The 本製品 uses the SAP Concur APIs to process filters that refer to ReportId, UserId, and ContextType. The 本製品 processes other filters client-side within the 本製品.
All three filters are required to query ReportComments. If ReportId is not specified, the 本製品 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 | 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. | |
| UserId | String | The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| 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. |