Focal Point
[SOLVED] Obtaining user email

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

August 31, 2018, 10:56 AM
Dave
[SOLVED] Obtaining user email
Hi all,

I'm trying to make an 'email-me' button. ( Managed Reporting )

But I'm unable to retrieve the user's emailaddress. ( yes, we do supply it when adding users )

It's not in the &IBIMR_ parameters I have.
Perhaps I can add it ( pass etc.. )
But I'm unable to find a complete list of all parameters that are passable?
only : "Useful variables include".


I'm able to get it using this:
http:///ibi_apps/WFServlet?IBFS1_action=getUser&IBFS_name=dave


But I need it in FEX, not script.
Although I know a workaround to get it, I find it very odd that I can not query the repository nor find it in the internal parameters?


greets,Dave

This message has been edited. Last edited by: Dave,


_____________________
WF: 8.0.0.9 > going 8.2.0.5
August 31, 2018, 11:57 AM
Tony A
If you add it to the user via the security centre, then you'll locate it in UOA_USERS.

However, if you are using external authentication then I am not sure if this is brought in to the repository or not.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
September 02, 2018, 05:18 PM
Waz
The email does get populated with external security, at least with our external security set up.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

September 03, 2018, 03:39 AM
Dave
Thanks so far...

We use single-signon with WIA ( AD ), whatever you call it.

Windows-account.

But we do explicitly add users to Webfocus.
We, manually, provide email-address there.

only thing to do is find out how to access UOA_USERS.
[ have to talk to the admin's ]

Greets,dave

This message has been edited. Last edited by: Dave,


_____________________
WF: 8.0.0.9 > going 8.2.0.5
September 03, 2018, 03:45 AM
Tony A
Hi Dave,

UOA_USERS is a table withn the WF Repository, so it depends on what RDBMS you use - If you use the standard Derby then you would need a JDBC adapter licence otherwise the adapter licence for the RDBMS that you use.

Also see if "Synchrobise User Information" is available on the release that you are using.

Is there any prospect of you upgrading? Or are you planning on sticking on 8.0.09?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
September 03, 2018, 03:53 AM
Dave
Hi, Tony,

thanks for the swift reply.

I think the repository is in SQL-server somewhere. ( or even Teradata ).
I'll have to talk to the admins.



We're right in the middle of upgrading to 8203
Client and Servers installed, but some trouble getting it up and running. ( authorisation, dmz, ports, ip's etc. )

Then we're going to 'sandbox' it for a while, see what we can do.
After that's we'll move to 8203.

I use the word 'move' because we will not migrate 'as is'.
New autorisations, new portals, etc.etc.

We did a migration from 7 to 8, and now we're stuck with a lot of legacy WF7 stuff. E.g. autorisation based on Domains etc.

Great oppurtunity to get rid of that...


_____________________
WF: 8.0.0.9 > going 8.2.0.5
September 03, 2018, 03:59 AM
Tony A
Good luck Smiler You'll appreciate the improvements from 8.0.09

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
September 03, 2018, 05:21 AM
Dave
Got it!
it works..


_____________________
WF: 8.0.0.9 > going 8.2.0.5