and more in a single search tool across platforms. Read the announcement here. |
02/07/2023 02:46 AM
Dear All,
How we can get user firstname, user last name, manager firstname,manager lastname.
I tried to create this query but not getting any data however data exist in database.
select u1.firstname,u1.lastname,u1.username,u2.firstname,u2.lastname,u2.username from users u1,users u2 where u1.owner=u2.userkey
02/07/2023 03:12 AM
select
u.username AS 'Username',
u.FIRSTNAME as 'First Name',
u.LASTNAME AS 'Last Name',
u.Companyname as company,
u.employeetype as employeetype,
u.CREATEDATE as 'date created',
m.username AS 'Manager Username',
m.displayname as 'Manager Name',
u.OWNER as Owner
from users u,
users m
where u.manager = m.userkey
and u.statuskey = 1