Retrieving User's E-mail Address

[OzWolf]

Ok, the need to conquer continuing customisation problems continues.

This time, I am trying to retrieve the e-mail address of a particular user account. I can get the username, full name and description without a problem but the e-mail address continues to elude me. I haven't been able to find anything in the CE SDK.

Can anybody help me with this?

Cheers.

 

[KingfisherINC]

SELECT SI_EMAIL_ADDRESS FROM CI_SYSTEMOBJECTS
WHERE SI_PROGID = 'CrystalEnterprise.USER'
AND SI_NAME = 'Administrator'

Kingfisher [CECP]

 

[mdwyer]

The query is valid, but where do you enter an email address for the user? The Properties page in the CMC (CE9) has Account Name, Full Name, Description, and Password.

My customized ePortfolio generates an email address from the account name and a fixed domain.

 

[KingfisherINC]

There is an additional input for Email in CE10 (I thought OzWolf was using v10 for some reason).

Kingfisher [CECP]

 

[mdwyer]

That would be my guess as well, as that's the most likely reason the question was asked. Seeing that CE9 supports the query - although no data is returned - suggests that the data item may be supported if one were to create a custom front end to supply it.

Does anyone know if the CE9 APS will support an email address value for the user?

 

[OzWolf]

Thanks KingFisher...worked a treat.

And sorry, I am using CE10.

For mdwyer: In CE9, you can store an e-mail address for a user but you need to build a custom interface to do so and then use the setProfileString and getProfileString methods for the User object. This way, you can define custom attributes for the user and store the value for them.