MicroStrategy ONE

List Contact Properties statement

Lists the properties of a contact.

Copy
LIST [ALL] PROPERTIES FOR CONTACT 
 "contact_name";

where:

CONTACT "contact_name" is the name of the contact to list the properties for, of type string.

Example

Copy
LIST ALL PROPERTIES FOR CONTACT "Michael White";

ResultSet columns

ID: The GUID for the contact.

NAME: The contact name.

DESCRIPTION: The description of the contact.

LINK_USER: The MicroStrategy user to whom the contact is linked. The linked user's security profile settings are used for the contact.

ENABLED: Whether the contact is enabled.

ADDRESSES: The address information for the contact.

  • NAME: The name of the address.

  • PHYSICAL_ADDRESS: The actual address, such as "mcwhite@workplace.com" if the DELIVERYTYPE is EMAIL.

  • DELIVERY_TYPE: The type of address this is. Can be Email, Print, or File.

  • DEVICE: The type of device used to make deliveries to the address.

  • ADDRESS_DEFAULT: Whether this is the default address for the contact.