Gets all history specified in a sourcing project.

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.

• ProjectId supports the '=' comparison operator.

For example, the following query is processed server side:

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.