Focal Point
[resolved] Showing name instead of user id in the Alert wizard?

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

May 17, 2010, 02:33 PM
Moogle
[resolved] Showing name instead of user id in the Alert wizard?
Hi Team,

I wonder if there is a way to show the full name in the alert wizard of the recipient (AKA To) instead of the MRE userid?

My client has a valid concern, which is that they do not know who 'X123456' is, but they do know people by name.

Cheers,

Joey

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


-WebFOCUS 8.2.01 on Windows
May 18, 2010, 01:36 PM
Rob Recker
This functionality is easily changed. To change the Users ID to their email address follow these simple steps:

- Edit /ibi/apps/mainstreet/alert_edit.fex
- Change line 121

from >
 var theFEX       = buildFEX("OWNERS", "OWNER_ID", "A12", "OWNER_EMAIL", "A64", null, null, null) ; 

to >
 var theFEX       = buildFEX("OWNERS", "OWNER_EMAIL", "A12", "OWNER_EMAIL", "A64", null, null, null) ; 


- Save changes
- Clear browser cache

Now when you bring up the Alert Wizard you will see a list of the owner email addresses instead of the user id's.





 Rob Recker
  Information Builders
800 . 736 . 6130
June 28, 2010, 06:48 PM
Moogle
Hi Rob,

I wonder if you can tell me a similar technique, one that returns the full name of the owner instead of the email or ID?

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
June 29, 2010, 09:22 AM
Moogle
Hi again,

I didn't mention that the user would like the name to show as LASTNAME, FIRSTNAME. I see that the javascript funtion only returns a single field, so I don't anticipate this being possible. Regardless, I appreciate your thoughts on the subject.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
June 29, 2010, 10:00 AM
Bob Jude Ferrante
O ye of little faith. Haven't you noticed PMF already displays Owners by Full Name using Last, First elsewhere in the app?

Have a look at OWNERS.MAS which is in your pmf[rdbms] folder (e.g., pmfmss, pmfora, etc.). There is a FULL_NAME field already defined there - wonder of wonders. It's an A67.

Working from the code above you'd use:

 var theFEX       = buildFEX("OWNERS", "FULL_NAME ", "A67", "OWNER_EMAIL", "A64", null, null, null) ; 


Note this would be a modification to the Alert Wizard so you'd have to follow the usual standards to customize it. Alert Wizard is likely to change over time, so you might have to put this mod in again. Luckily it's an easy one.

thanks

This message has been edited. Last edited by: Bob Jude Ferrante,


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

June 29, 2010, 10:53 AM
Moogle
Hey, this is excellent news. Thanks Bob.

Cheers,

Joey
June 30, 2010, 04:42 PM
Bob Jude Ferrante
Note that in the example at the top, the OWNER_EMAIL field length is stated wrong; it should be "A64" not "A12".


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!