Display First, Last users' names for workflow SQL form fields

Russell_Clark

Hi -I have a simple LiveReport on a form (storage mechanism SQL table) used in a Workflow that reports users that are entered as User fields in the form:select id "ID", volumeid "Workflow ID", WORK_DATEINITIATED "Last Updated", lastname "LastName", firstname "FirstName" , name "Login Name", Reviewer1 "Reviewer1", Manager_or_Approver "Manager_or_Approver" from kuaf, zEFSO_SOP_2, wwork where wwork.work_workid = zEFSO_SOP_2.volumeid and kuaf.id = wwork.work_ownerid order by WORK_DATEINITIATED descThe lastname and firstname items above give the Workflow initiator data. But for the Reviewer1, Manager_or_Approver, I'm only getting the Livelink user ID (not the login or "real" name). Can anyone help me with the LiveReport SQL needed to do the lookup so I can report actual names for those instead of just the LL User ID number? I think this form table is like any other SQL form data.Thanks,Russ

eLink User

Message from Nair, Krishnankutty N. via eLinkSee if this will work on a DEV environment-all this is doing is aliasingKUAF again as b and since you said the kuaf.id=reviewer1 use thatrelation.It also makes sense if you use aliasesselect id "ID", volumeid "Workflow ID", WORK_DATEINITIATED "LastUpdated", lastname "LastName", firstname "FirstName" , name "LoginName", Reviewer1 "Reviewer1",b.FirstName,b.LastName,b.name,Manager_or_Approver "Manager_or_Approver" from kuaf,kuaf b,zEFSO_SOP_2, wwork where wwork.work_workid = zEFSO_SOP_2.volumeid andkuaf.id = wwork.work_owneridAnd b.id=reviewer1 order by WORK_DATEINITIATED desc Run Describe KUAF and then use b.that fieldname what you want to get.Ihave not tried this,but I have a feeling my sql is right(I do not haveyour table zEFSO_SOP_2 structure,hence this kind of debugging,if you canpost a describe on that or a script to create that I can really testthis)-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, February 27, 2006 10:53 AMTo: eLink RecipientSubject: Display First, Last users' names for workflow SQL form fieldsDisplay First, Last users' names for workflow SQL form fieldsPosted by Clark, Russell S on 02/27/2006 11:49 AMHi -I have a simple LiveReport on a form (storage mechanism SQL table) usedin a Workflow that reports users that are entered as User fields in theform:select id "ID", volumeid "Workflow ID", WORK_DATEINITIATED "LastUpdated", lastname "LastName", firstname "FirstName" , name "LoginName", Reviewer1 "Reviewer1", Manager_or_Approver "Manager_or_Approver"from kuaf, zEFSO_SOP_2, wwork where wwork.work_workid =zEFSO_SOP_2.volumeid and kuaf.id = wwork.work_ownerid order byWORK_DATEINITIATED descThe lastname and firstname items above give the Workflow initiator data.But for the Reviewer1, Manager_or_Approver, I'm only getting theLivelink user ID (not the login or "real" name). Can anyone help me with the LiveReport SQL needed to do the lookup so Ican report actual names for those instead of just the LL User ID number?I think this form table is like any other SQL form data.Thanks,Russ[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.