My Groups

Birger_Jacobsen_(danskadmin_-_(deleted))

Since our users are exluded from using there Personal workspace, I made this Report to help them finding thegroups they belong (change from week to week). Is there any way to make it dependant of who is the actual user :select c.firstname "Firstname" , c.lastname "Lastname", c.mailaddress "Email", b.Name "Member of" from KUAFChildren a,KUAF b,KUAF c where a.ID=b.ID and a.ChildID=c.ID and c.name like %1%1 = user input Type = string (The user type his/her own username)Any Idea ?

Find more posts tagged with

Comments

Stephanie_Ellis_(HARMUser1_(Delete)_2309475)

One of the PARAM choices is "UserID". Try using this for %1 instead of the user input:c.name = %1

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

Actually, this returns the user's ID number, so you'll need to adjust the SQL to test based on c.ID = %1 instead of c.name.

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Livelink LiveReports Discussion
Sent: Monday, November 12, 2001 11:23 AM
To: eLink Recipient
Subject: One of the PARAM choices is "UserID". Try using this for %1 instead of the user...

One of the PARAM choices is "UserID". Try using this for %1 instead of the user... Posted by HARMUser1 (Ellis, Stephanie) on 11/12/2001 12:20 PM
In reply to: My Groups Posted by DanskAdmin (Souary, Idriss) on 11/12/2001 11:05 AM

One of the PARAM choices is "UserID". Try using this for %1 instead of the user input:

c.name = %1