Create, update, delete, and query User Identities.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.

SELECT * FROM UserIdentities

SELECT * FROM UserIdentities WHERE UserId = '123'

SELECT * FROM UserIdentities WHERE UserId = '123' AND Id='345'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

The Type, Value, and UserId fields are required to insert. Allowed for agents.

INSERT INTO UserIdentities(Type, Value, UserId) VALUES('email', '[email protected]', '123')

Update

You must specify the Id of the identity and UserId to update. Allowed for agents. Update allows you to do the following: Set the specified identity as verified (but you cannot unverify a verified identity). Note: Primary should be true.

UPDATE UserIdentities SET Verified=true WHERE UserId = '123' AND Id = '456'

Update the value of the specified identity:

UPDATE UserIdentities SET Value='[email protected]' WHERE UserId = '123' AND Id = '456'

Delete

You must specify the Id of the identity and UserId to delete an user identity. Users must have at least one identity after deletion. Allowed for agents.

DELETE FROM UserIdentities WHERE UserId = '123' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned on creation.
UserId	Long	False	Users.Id	The id of the user.
Type	String	False		One of email, twitter, facebook, google, or phone_number.
Value	String	False		The identifier for this identity, such as an email address.
Verified	Boolean	False		If the identity has been verified.
Primary	Boolean	True		If the identity is the primary identity. Writable only when creating, not when updating.
CreatedAt	Datetime	True		The time the ticket field was created.
UpdatedAt	Datetime	True		The time of the last update of the ticket field.
UndeliverableCount	Integer	True		The time of the last update of the ticket field.
DeliverableState	String	True		The time of the last update of the ticket field.
Url	String	True		The URL for this resource.