Any LiveReport that shows who's a member of a particular group?

Hi,Is there a LiveReport that allows me to select(type in group name) and have it show all the members of that particular group? Your help is always appreciated. Thanks.Gil

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkOf course. Call for details.Alex KowalenkoSenior Consultant - Open Text Professional Services+1 613 838-5220alexk@opentext.com-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, February 08, 2001 8:58 PMTo: eLink RecipientSubject: Any LiveReport that shows who's a member of a particular group?Any LiveReport that shows who's a member of a particular group?Posted by gbatac on 02/08/2001 08:57 PMHi,Is there a LiveReport that allows me to select(type in group name) and haveit show all the members of that particular group? Your help is alwaysappreciated. Thanks.Gil[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Robert_Davies_(unlondonadmin_-_(deleted))

Attached is a text file containing a version of an Autoreport that I created which allows you to enter a numeric Group Id or a numeric User Id or a Group name or a User Id and subsequently find out who is in a group or what groups a user belongs to. It is very flexible but for any input field you are not using you have to enter %% which is a bit of a pain at times.I have found it useful in identifying all groups a user is a member of, what group(s) a user is a member of, who are the members of a given group, and finding out what group/user a numeric code refers to in the Dtree table. Please let me have any comments. Obviously this report could be adapted to perform only one of these functions. I have a version where I use the group name as the sort order. The SQL only needs to change the ORDER BY statement to ORDER BY b.name.Anne Callanan

Gil_Batac_(gbatac_-_(deleted))

Thank You to all who have been of great help. I hope you all don't mind helping me with other requests in the near future.Gil

Alex_Kowalenko_(akowalen_(Delete)_2285456)

The attached LiveReport eXport file contains 2 LiveReports - one that lists members of a group and the other that lists all members of groups including members of all subgroups.

Alex_Kowalenko_(akowalen_(Delete)_2285456)

Remove the pain by appending || '%%' to the end of your selection criteria. Then you can leave string input fields blank to select all values.Example:where name like '%1' || '%%'

Alex_Kowalenko_(akowalen_(Delete)_2285456)

I've attached a text file with 2 LiveReports that finds all Groups for a user and Users for a group. Because the Livelink group structure can be nested the report must go throught the hierarchy of nested groups to find all members. See Notes section in the attached for more explanations.

Support_Lloyds_Register

Alex, can you please help in providing the query to select a group in live report?

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Let me know if my posting here:

https://knowledge.opentext.com/go/7637720

...is of help in this regards.

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, July 21, 2009 9:48 AM
To: eLink Recipient
Subject: LiveReport that shows who's a member of a particular group?

LiveReport that shows who's a member of a particular group?		Posted by lloydsuser2 (Kashelkar, Vishal) on 2009/07/21 09:44
In reply to: RE Any LiveReport that shows who's a member of a particular group?		Posted by eLink on 2001/02/08 21:48

Alex, can you please help in providing the query to select a group in live report?