MicroStrategy ONE
List Contact Properties statement
Lists the properties of a contact.
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
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.