All users by their default group in Livelink?

Dragan_Jichici

I have a livereport that will show me all the users in Livelink and the groups they are a part of. However I need a query to find out every Livelink user's default group. Does anyone have such a report?SELECT A.Name as "Group", (Select Z.lastname from KUAF Z where z.id = B.childID) as "Name",(Select Z.firstname from KUAF Z where z.id = B.childID) as "Firstname",(Select Z.name from KUAF Z where z.id = B.childID) as "User" FROM KUAF A, KUAFChildren B Where A.id <> 1001 AND A.id = B.ID AND A.Type = 1 Order by 1,2Thank you,Dragan

Drane_Matthew

Message from Drane, Matt <mdrane@hasbro.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try this:

 

select kuaf.name as userid,kuaf.lastname,kuaf.firstname,department.name as department,kuaf.mailaddress
from kuaf
inner join kuaf department on department.id = kuaf.groupid
where kuaf.deleted=0 and kuaf.type = 0
order by kuaf.lastname,kuaf.firstname

 

---

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, April 07, 2006 11:39 AM
To: eLink Recipient
Subject: All users by their default group in Livelink?

 

All users by their default group in Livelink?

Posted by draganjichici (Jichici, Dragan) on 04/07/2006 11:36 AM

I have a livereport that will show me all the users in Livelink and the groups they are a part of. However I need a query to find out every Livelink user's default group. Does anyone have such a report? SELECT A.Name as "Group", (Select Z.lastname from KUAF Z where z.id = B.childID) as "Name",(Select Z.firstname from KUAF Z where z.id = B.childID) as "Firstname",(Select Z.name from KUAF Z where z.id = B.childID) as "User" FROM KUAF A, KUAFChildren B Where A.id <> 1001 AND A.id = B.ID AND A.Type = 1 Order by 1,2 Thank you, Dragan