JDBC Driver for SAP Ariba Source

Build 23.0.8839

TaskCommentAttachments

Retrieve all task comments attachments.

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.
  • ProjectId supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM TaskCommentAttachments WHERE TaskId = 'TSK17371161'

SELECT * FROM TaskCommentAttachments WHERE ProjectId = 'WS12345'

Columns

Name Type References Description
TaskId [KEY] String

Tasks.InternalId

Specifies internal Id of specified task.
CommentId [KEY] String

TaskComments.Id

Specifies unique Id genarated for each task history record.
Id [KEY] String Specifies internal ID for the attachment, assigned by SAP Ariba.
FileName String Specifies name of the file.
DocumentType String Specifies the document's type. (doc/Choice/Workspace).
DocumentTypeUiName String Specifies the Document type. (Document/Choice/Sourcing Project) - UI name of the document type.
ContentType String Specifies MIME content type such as text/csv or image/png , this value is set based on the type of file.
Size Long Specifies length of the attachment, in bytes. Ignored in POST requests.
CanDownload Bool Set to true, when attachment/document is downloadable, otherwise 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