[SOLVED] how to get email address from the user profile

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1647016196

September 06, 2019, 12:03 PM

vnf

[SOLVED] how to get email address from the user profile

Hello,

I am just wondering if there is a web focus function that can return the email address of the user that is login?
I know I can get the user name using &FOCSECUSER

thanks,

Vera

This message has been edited. Last edited by: FP Mod Chuck,

WebFOCUS 8.2.0.7,
Application Studio,
Webfocus Info-Assist
iWay Service Manager,
iWay Data Migrator
Windows, All Outputs
IBM DB2/400, MS SQL-Server 2014

September 06, 2019, 12:21 PM

FP Mod Chuck

Hi Vera

The repository table UOA_USERS has the e-mail address. You can look it up using the field NAME in you WHERE statement.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

September 06, 2019, 02:26 PM

vnf

thank you

WebFOCUS 8.2.0.7,
Application Studio,
Webfocus Info-Assist
iWay Service Manager,
iWay Data Migrator
Windows, All Outputs
IBM DB2/400, MS SQL-Server 2014