History
Gets all history specified in a sourcing project.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- ProjectId supports the '=' comparison operator.
SELECT * FROM History WHERE ProjectId = 'WS12345'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Specifies ID of the history record of the sourcing project. | |
Title | String | Specifies the title of the respective history record. | |
Details | String | Specifies the sourcing project details. Possible values: active, inactive. | |
Type | String | Specifies the type of object for the history record. Possible values: Document, Workspace, Folder. | |
Description | String | Specifies the description related to the sourcing project. Possible values: startDate, status,owner. | |
Timestamp | Datetime | Specifies the date and time of the respective history record. | |
EffectiveUserName | String | Specifies the name of the user. | |
EffectiveUserUniqueName | String | Specifies the unique name of the user. | |
EffectiveUserEmailAddress | String | Specifies the email address of the user. | |
RealUserName | String | Specifies the name of the user. | |
RealUserUniqueName | String | Specifies the unique name of the user. | |
RealUserEmailAddress | String | Specifies the email address of the user. | |
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. |