Users by group

Pfizer_Developers

We have a need for a simple Live Report that will query all users that belong to a specific group in the livelink database. I want it so a user will be able to choose the group like they normally would through the Livelink UI.

Robert_Davies_(unlondonadmin_-_(deleted))

This is one report I use that may give you the results you want:Inputs:Type Promptstring GroupIdstring UserIdstring Group Namestring User NameSQLselect c.Name "User Name",c.mailaddress "Email",c.title,c.firstname,c.lastname,c.contact "Cont.",b.Name "Group Name",a.ID,a.ChildID from KUAFChildren a,KUAF b,KUAF c where a.ID=b.ID and a.ChildID=c.ID and a.ID like %1||'%%' and a.ChildID like %2||'%%' and (b.name like %3||'%%' or lower(b.name) like %3||'%%' or upper(b.name) like %3||'%%') and (c.name like %4||'%%' or lower(c.name) like %4||'%%' or upper(c.name) like %4||'%%') order by lower(b.name),c.lastname,c.firstnameParam %1 User Input 1Param %2 User Input 2Param %3 User Input 3Param %4 User Input 4Report Format Auto LivereportAlthough this report allows input of the numeric Group/User ID (full or partial) and the User name or Group name (full or partial) any or all the inputs can be left blank. If you remove inputs 1,2,4 obviously the report would just produce Group membership for a given group name. Also the report is designed to be case insensitive.Let me know if this is the type of thing you were looking for.Best regardsAnne