Name

This object is used to retrieve information from related records where the related record may be from more than one object type (a polymorphic foreign key). For example, the owner of a case can be either a user or a group (queue). This object allows retrieval of the owner name, whether the owner is a user or a group (queue). You can use a describe call to access the information about parents for an object, or you can use the who, what, or owner fields (depending on the object) in SOQL queries. This object cannot be directly accessed.

Supported Calls and Queries

Calls: describeSObjects()

SOQL: SELECT (including the WHERE clause), ORDER BY

Fields

Field Field Type Field Properties Description
Alias string Filter

Nillable

The user alias. This field contains a value only if the related record is a user.
Email string Filter

Nillable

The email address of the user. This field contains a value only if the related record is a user .
FirstName string Filter

Nillable

If the related record is a user, contact, or lead, the first name.
IsActive boolean Filter

Nillable

Indicates whether the related record is an active user (true) or not (false). This field contains a value only if the related record is a user.
LastName string Filter

Nillable

If the related record is a user, contact, or lead, the last name.
Name string Filter

Nillable

Name of the parent of the object queried. If the parent is a user, contact, or lead, the value is a concatenation of firstname and lastname fields of the related record.
Phone string Filter

Nillable

The phone number of the user. This field contains a value only if the related record is a user.
Profile reference Filter

Nillable

The Profile of the user. Only populated if the related record is a user.
ProfileId reference Filter

Nillable

ID of the user’s Profile. Only populated if the related record.
Title string Filter

Nillable

The title of the user, for example CFO or CEO.
Type string Filter

Nillable

Restricted picklist

A list of the types of sObjects that can be an owner of this object. You can use this field to filter on a type of owner, for example, return only the leads owned by a user.
Username string Filter

Nillable

Contains the name that a user enters to log into the API or the Salesforce.com user interface. The value for this field is in the form of an email address, and is only populated if the related record is a user.
UserRole picklist Filter

Nillable

Name of the Role played by the user. Only populated for user rows.
UserRoleId reference Filter

Nillable

The ID of the user role associated with this object.

Usage

To query on relationships where the parent may be more than one type of object, use who, what, or owner relationship fields.

© Copyright 2000-2009 salesforce.com, inc. All rights reserved.
Various trademarks held by their respective owners.