JDBC Driver for SAP Ariba Source

Build 23.0.8839

TaskComments

Retrieve all tasks comments of a specified task.

View-Specific Information

Select

The driver uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • TaskId supports the '=' comparison operator.
  • IncludePreviousRounds supports the '=' comparison operator.
  • ProjectId supports the '=' comparison operator.
For example, the following queries areare processed server side:
SELECT * FROM TaskComments WHERE TaskId = 'TSK17371161'

SELECT * FROM TaskComments WHERE IncludePreviousRounds = 'true'

SELECT * FROM TaskComments WHERE ProjectId = 'WS12345'

Columns

Name Type References Description
TaskId [KEY] String

Tasks.InternalId

Specifies internal Id of specified task.
Id [KEY] String Specifies unique Id genarated for each task history record.
Comment String Comment.
Round String Specifies round number of the task.
User String User.
Attachments String Project TaskComment Attachment Details, Attachment which are downloadable or non-dowloadable can be identified by a flag canDownload.
AvailableActions String Available actions.
AccessControl String Access Control values can either allow or restrict the users who can view the content.
CreateDate String Specified the date on which comment is added to a specified task.
IncludePreviousRounds Bool If the value is set to true, comments from all the current and previous rounds are listed. If the value is set to false, only the current comments are retrieved. The default value is false.
ProjectId [KEY] String

Projects.InternalId

Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155.

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