Group Leader report

Hi,I am looking for a report that will list all Groups in Livelink and their associated Group Leaders. Also, if the Group Leader is another Group then the report recursively calls the live report to get the Group Leader of that Group. Thanks in advance.

Find more posts tagged with

Comments

CBancroft

Message from Chris Bancroft <cbancrof@opentext.com> via eLink

eLink

Hello Jay,

Here are some samples:

=============

get the groups and the users who are part of them

==================

SELECT a.Name "Groups", c.Name "Users"

FROM KUAF a, KUAFChildren b, KUAF c

WHERE a.ID = b.ID AND b.ChildID = c.ID AND a.Type=1 AND c.Type=0

ORDER BY a.Name

====================

Get group leaders

===================

select k1.name, k2.firstname, k2.lastname

from kuaf k1, kuaf k2

where k1.deleted=0

and k1.leaderid = k2.id

neither is recursive however it is a place to start

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, April 13, 2011 1:54 PM
To: eLink Recipient
Subject: Group Leader report

Group Leader report

Posted by jay.york@williams.com (York, Jay) on 2011/04/13 13:52

Hi,

I am looking for a report that will list all Groups in Livelink and their associated Group Leaders. Also, if the Group Leader is another Group then the report recursively calls the live report to get the Group Leader of that Group.

Thanks in advance.

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Evert_Kuiken_(ekuiken_-_(deleted))

Message from Kuiken, Evert <Evert.Kuiken@alliander.com> via eLink

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

This is what I can contribute:

Input: group name (with or without wildcards)

Results:

Groep Users Beheerder (Group leader) Actions NIT Informatiemanagement & ICT 15 (NIT Informatiemanagement & ICT

Details

Details links to another LR that shows details of the 15 Users in the group. It should be easy to show details of the Group Leader group.

Query:

Database Options: Transaction Mode Fetch Cursor Mode Allow Database Modification Enabled Enabled Disabled<!- End data item - Database Options --> <!- Start data item - SQL Source --> SQL: SELECT groep.NAME AS "Groep",
(SELECT COUNT (*)
FROM kuaf, kuafchildren
WHERE kuafchildren.id = groep.ID AND kuaf.ID = kuafchildren.CHILDID AND kuaf.TYPE=0)
AS "Users",
(SELECT leader.firstname || ' ' || leader.lastname || ' (' || leader.NAME || ')'
FROM kuaf leader
WHERE groep.leaderid = leader.ID)
AS "Beheerder (Group leader)"
FROM kuaf groep
WHERE groep.NAME LIKE %1 AND groep.TYPE = 1 AND groep.DELETED = 0<!- End data item - SQL Source --> <!- Start data item - inputs --> Inputs: # Prompt Type Prompt Text 1 String Geef de groepsnaam (wildcards zoals '%' toegestaan)<!- End data item - inputs --><!- Start data item - Parms --> Parameters: % Parameter Type %1 User Input 1<!- End data item - Parms --><!- Start data item - Templates --><!- End data item - Templates --> <!- Start data item - Show Prompts --> Show Prompts: Enabled <!- End data item - Show Prompts--><!- Start data item - Report Format --> Report Format: autoreport

Regards, Evert

RE Group Leader report		Posted by cbancrof (Bancroft, Chris G) on 2011/04/13 14:53
In reply to: Group Leader report		Posted by jay.york@williams.com (York, Jay) on 2011/04/13 13:52

Hi,

I am looking for a report that will list all Groups in Livelink and their associated Group Leaders. Also, if the Group Leader is another Group then the report recursively calls the live report to get the Group Leader of that Group.

Thanks in advance.

Jay_York

I have this in my live report and it works to list the groups and group leader. select a.ID, a.name "Group Name", b.name "Group Leader" from KUAF a, KUAF b where a.Type=1 and a.leaderID=b.ID and a.Deleted=0 I guess I need to figure out how to call it recursively so that it can run against a group that is listed as group leader. Any ideas?