Get user description[SOLVED]

Hi
Couldn't find the answer anywhere to a simple question.
Is there a variable to get the full "User Description" field of the current user?
Like &IBIC_user or &IBIMR_memberof but for the user description, not the ID.

Thank you in advance!

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

Wf 8005 Centos 6.4

Posts: 16 | Registered: April 07, 2011

MartinY

Virtuoso

posted

Hide Post

I don't think that there is a variable that contain the full name, but you can find it in WF Repos table:

SELECT [NAME], [DESCRIPTION]
  FROM [WebFocus_Repos].[dbo].[UOA_USERS]

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Show Post

GavinL

Master

posted

Hide Post

You'll have to create a synonym off the JDBC Adapter.. "jdbc:derby://127.0.0.1:1527/WebFOCUS81", if you don't already have one, but like he said above, you can pull it from UOA_USERS.

SET ASNAMES = MIXED

-DEFAULT &Username = _FOC_NULL:
-DEFAULT &Fullname = _FOC_NULL:

TABLE FILE gavin_test/uoa_users
BY UOA_USERS.UOA_USERS.NAME AS 'Username'
BY UOA_USERS.UOA_USERS.DESCRIPTION AS 'Fullname'
WHERE UOA_USERS.UOA_USERS.NAME EQ '&IBIMR_user'
ON TABLE HOLD AS USERHOLD FORMAT ALPHA
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
END
-RUN

-READFILE USERHOLD

-SET &Username = TRUNCATE(&Username);
-TYPE Username = &Username;
-SET &Fullname = TRUNCATE(&Fullname);
-TYPE Fullname = &Fullname;