TeamUsers
Retrieve team user information specified in a sourcing project.
View-Specific Information
Select
The component uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.
- TeamId supports the '=' comparison operator.
- ProjectId supports the '=' comparison operator.
SELECT * FROM TeamUsers WHERE TeamId = 'PG17371157'
SELECT * FROM TeamUsers WHERE ProjectId = 'WS12345'
Insert
Users can be added to a specific project team by executing INSERT statements. A user is uniquely identified by a combination of uniqueName and passwordAdapter. For example:
INSERT INTO TeamUsers (UniqueName,PasswordAdapter, TeamId) VALUES ('testName','1234','100')
Columns
Name | Type | ReadOnly | References | Description |
TeamId [KEY] | String | False |
Teams.Id |
Specifies the unique identifier of the project group. |
TeamName | String | False |
Specifies the name of the project group. | |
TeamType | String | False |
Specifies the type of the project group. Possible values- ProjectGroup, GlobalGroup. | |
Type | String | False |
Specifies the user type. | |
Name | String | False |
Specifies the full name of the user. | |
UniqueName [KEY] | String | False |
Specifies the unique name of the user. | |
PasswordAdapter | String | False |
Specifies the password adapter of the user. | |
EmailAddress | String | False |
Specifies the email address of the user. | |
TimeZoneId | String | False |
Specifies time zone for the user. Example: Asia/Kolkata. | |
Organization | String | False |
Specifies the organization name of the user. | |
ProjectId [KEY] | String | False |
Projects.InternalId |
Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155. |