JDBC Driver for SAP Concur

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839