Gets the details of all the users in a specific project.

Select

• Id supports '=' operator
• Email supports '=,!=,CONTAINS' operators
• BusinessHoursId supports '=,!=,CONTAINS' operators
• ProjectProfileId supports '=' operator
• PortalProfileId supports '=' operator
• RoleId supports '=' operator
• UserType supports '=' operator
• ViewType supports '=' operator

• Columns that support server-side ORDER BY: Id, FirstName, LastName, ProjectProfileName, PortalProfileName, RoleName, AddedToProjectTime, UpdatedInProjectTime, LastAccessedOn

For example, the following query is processed server side:

SELECT * FROM ProjectUsers WHERE Id = '460276000000139095'

Insert

To add a new Project User you can specify the following fields:

• Email
• ProjectProfileId
• RoleId
• ProjectCostRateAmount
• Notify

INSERT INTO ProjectUsers(Email, Notify) VALUES ('[email protected]', true)

Update

To update a Project User specify the Id field.

UPDATE ProjectUsers SET ProjectCostRateAmount = 2 WHERE Id = '123456000000045018'

Delete

ProjectUsers can be deleted by providing the Id and Notify fields and issuing a DELETE statement.

DELETE FROM ProjectUsers WHERE Id = '123456000000045018' AND Notify = true

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	User Id.
FirstName	String	True	User First Name.
LastName	String	True	User Last Name.
FullName	String	True	User Full Name.
IsConfirmed	Boolean	True	User Is Confirmed.
IsResendInvite	Boolean	True	User Is Resend Invite.
Email	String	False	User Email.
BusinessHoursId	Long	True	User Business Hours Id.
BusinessHoursName	String	True	User Business Hours Name.
ProjectProfileId	Long	False	User Project Profile Id.
ProjectProfileName	String	True	User Project Profile Name.
ProjectProfileIsCustomized	Boolean	True	User Project Profile Is Customized.
PortalProfileId	Long	False	User Portal Profile Id.
PortalProfileName	String	True	User Portal Profile Name.
PortalProfileIsDefault	Boolean	True	User Portal Profile Is Default.
ReportingToId	Long	True	Reporting To Id.
ReportingToFirstName	String	True	Reporting To First Name.
ReportingToLastName	String	True	Reporting To Last Name.
ReportingToZuid	Long	True	Reporting To Zuid.
RoleId	Long	False	User Role Id.
RoleName	String	True	User Role Name.
Zuid	Long	True	User Zuid.
UserType	String	True	User Type. The allowed values are portal_user, client_user, client_contact.
Status	String	True	User Status.
AddedToProjectTime	Datetime	True	User Project Added Time.
UpdatedInProjectTime	Datetime	True	User Project Updated Time.
ProjectCostRateCurrencyCode	String	True	Currency code of the project cost rate.
ProjectCostRateFormattedAmount	String	True	Formatted amount of the project cost rate.
ProjectCostRateAmount	Decimal	False	Project cost rate amount.
CostEffectiveDate	Date	True	Cost effective date.
LastAccessedOn	Datetime	True	User Last Accessed On Time.
ViewType	String	True	View type. The allowed values are active, inactive, active_read_only, inactive_read_only, subordinates_active, direct_reports_active, activate_user_request, sandboxdevelopers.
Notify	Boolean	False	Specify whether to notify the user about the removal. Required to use when deleting a user.