Help modifying a group livereport

Robert James

I have a livereport that collects all group names and the users in these groups.  The user is displayed in a column with the login name.  Is there a way to modify this report to include columns for firstname and lastname?  Our database is SQL:

Select KC.ID 'Group ID' ,K.Name 'Group Name', K1.ID 'Child ID' ,K1.Name 'Child Name', CASE WHEN K1.GroupID IS NULL THEN 'SubGroup' ELSE '' END 'SubGroup'FROM llprod.KUAFChildren KC Inner Join KUAF K ON KC.ID =K.ID Left Outer Join KUAF K1 ON KC.ChildID =K1.ID Where K.Type in (0,1) And K1.Type in (0,1)Order by 1,3

Thanks!

Colin_Schmidt

Try the code below.

 

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, June 06, 2016 11:46 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Help modifying a group livereport

 

Help modifying a group livereport

Posted by James, Robert On 06/06/2016 11:42 AM

 

I have a livereport that collects all group names and the users in these groups.  The user is displayed in a column with the login name.  Is there a way to modify this report to include columns for firstname and lastname?  Our database is SQL: Select KC.ID 'Group ID' ,K.Name 'Group Name', K1.ID 'Child ID' ,K1.Name+’[‘+k.firstname+’ ‘+k.lastname+]’ 'Child Name', CASE WHEN K1.GroupID IS NULL THEN 'SubGroup' ELSE '' END 'SubGroup'FROM llprod.KUAFChildren KC Inner Join KUAF K ON KC.ID =K.ID Left Outer Join KUAF K1 ON KC.ChildID =K1.ID Where K.Type in (0,1) And K1.Type in (0,1)Order by 1,3 Thanks!

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

 

---

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.