ProjectUsers
Retrieves list of users associated with a project. Also, get details of a user in project.
Table Specific Information
Select
The component will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
- ProjectId supports the '=' comparison.
- UserId supports the '=' comparison.
SELECT * FROM ProjectUsers WHERE ProjectId = '1894553000000072363' AND UserId = '1894553000000056001'
Columns
Name | Type | References | SupportedOperators | Description |
ProjectId | String |
Projects.ProjectId | Id of a project. | |
UserId [KEY] | String |
Users.UserId | Id of the user. | |
IsCurrentUser | Boolean | Check if it is a current user. | ||
UserName | String | Username of the project users. | ||
String | Email ID of user. | |||
UserRole | String | Role of the user in project. | ||
RoleId | String |
Users.RoleId | ID of the role. | |
Status | String | Status of the project user. | ||
Rate | Decimal | Hourly rate for a task. | ||
BudgetHours | Integer | Total number of hours alloted to the user for the project. | ||
BudgetHoursInTime | String | Time of total number of hours alloted to the user for the project. | ||
TotalHours | String | Total number of hours to be spent in project. | ||
BilledHours | String | Total number of billed hours to be spent in project. | ||
UnBilledHours | String | Total number of unbilled hours spent in project. | ||
BillableHours | String | Total number of billable hours spent in project. | ||
NonBillableHours | String | Total number of non billable hours spent in project. | ||
StaffRole | String | Role of staff in project. | ||
StaffStatus | String | Status of staff in project. |