You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a function to get the display name from the username?

Summary:


Content (required):

I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table to get the person_id from the username and then link to the per_person_names_f table to get the display name, but I need to get the same data from 2 tables, getting both the created by and last updated by from each table. This would entail having 4 separate subqueries to get the values. It would be much simpler if I could just call a function, passing the username.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!