Another User/Deparment SQL question

SBS_Admins_(ultrasbsadmin_-_(deleted))

I've got a problem that I can't seem to get my LiveReport to run properly and give me back a list of Username, FirstName, Lastname and Department (Primary Group).I can get the SQL to run locally and return the correct list.So far I have tried my own SQL statements and the following from this site: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.firstnameselect k.ID, k.Name, k2.Name from KUAF k, KUAF k2 where k.Type=0 and k.GroupID = k2.IDselect k1.id,k1.name,k1.groupid,k2.name "GroupName" from kuaf k1, kuaf k2 where k1.id=1000 and k1.groupid = k2.idselect a.name, a.lastname, a.firstname, b.name "Department", a.userprivileges from kuaf a, kuaf b where a.type=0 and a.groupid=b.idThe problem still being that I get either duplicate fields shown or fields with "An unknown feature was specified" shown.Can anyone tell me if there are other fields on the LiveReport screen that should have information entered into them or am I alright just entering the SQL field?I'm using Livelink 9.5.1 with an MS SQL backend.

Lindsay_Davies

Message from Lindsay Davies via eLinkHi,You will be doing this as an AutoLivereport (as you are not selectingDTree objects).My guess is you need to specify explicitly the output fields at thebottom of the Livereport edit page, using the table alias names to avoidambiguous references.For example, using the statement I prefixed with ">>>" .... k.Name Login k2.Name Department Not sure if you need to list all the columns you are selecting in thiscase.Try it and see.RegardsLindsayUK-Support Open Text-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 12 March 2007 15:41To: eLink RecipientSubject: Another User/Deparment SQL questionAnother User/Deparment SQL questionPosted by Admins, SBS C on 03/12/2007 11:37 AMI've got a problem that I can't seem to get my LiveReport to runproperly and give me back a list of Username, FirstName, Lastname andDepartment (Primary Group).I can get the SQL to run locally and return the correct list.So far I have tried my own SQL statements and the following from thissite:select kuaf.name as userid,kuaf.lastname,kuaf.firstname,department.nameas department,kuaf.mailaddress from kuaf inner join kuaf department ondepartment.id = kuaf.groupid where kuaf.deleted=0 and kuaf.type = 0order by kuaf.lastname,kuaf.firstname>>> select k.ID, k.Name, k2.Name from KUAF k, KUAF k2 where k.Type=0and k.GroupID = k2.IDselect k1.id,k1.name,k1.groupid,k2.name "GroupName" from kuaf k1, kuafk2 where k1.id=1000 and k1.groupid = k2.idselect a.name, a.lastname, a.firstname, b.name "Department",a.userprivileges from kuaf a, kuaf b where a.type=0 and a.groupid=b.idThe problem still being that I get either duplicate fields shown orfields with "An unknown feature was specified" shown.Can anyone tell me if there are other fields on the LiveReport screenthat should have information entered into them or am I alright justentering the SQL field?I'm using Livelink 9.5.1 with an MS SQL backend.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.