Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
LR for Form Based WF and Form Template
Mary_Slane_Corona
I have a form based workflow based on a form template with several user fields. I am attempting to do a LR to pull data out of the table that I developed for the form template. How do I convert the user fields from a number to the user name? Following is my LR. I am also attaching a screenshot of the results of the LR.SELECT f.WF_Rush "Rush", t.subwork_title "Workflow Name", f.dateinit "Initiated", f.requestor "Initiator", t.subworktask_dateready "CR Rcvd Step", f.PCR_Num "Project", f.BU_Num2 "BU #", f.Projtype "Project Type", f.Projtype_C "Project SubType", f.Dom_Int_Gbl, f.Brand "Brand", f.Flavor "Flavor", f.PKG_Comp "Component", f.Bottle_Size "Size", f.Facility "Facility", f.NPPM, f.SCADMIN FROM todo t, wsubwork w, FMSC_ATOWF f WHERE t.SubWorkTask_Title = 'CS PM' and w.subwork_subworkid = t.work_workid and w.subwork_subworkid = f.volumeid and t.work_workid = f.volumeid and f.versionnum = -1 and w.subwork_status != -1 ORDER BY t.subworktask_performerid_Name, t.subworktask_dateready
Find more posts tagged with
Comments
Appu_Nair
assumiing the numbers form your screencap like NPPM=8123 is a valid livelink kuaf.id one should be able to create a join something likeJust before your where clause kuaf k and somehere in the ands you can dok.id=f.nppmand in the report you can say k.name,k.firstname,k.lastnameI cannot see your full table but here's a trySELECT k.firstname,k.lastname,f.WF_Rush "Rush", t.subwork_title "Workflow Name", f.dateinit "Initiated", f.requestor "Initiator", t.subworktask_dateready "CR Rcvd Step", f.PCR_Num "Project", f.BU_Num2 "BU #", f.Projtype "Project Type", f.Projtype_C "Project SubType", f.Dom_Int_Gbl, f.Brand "Brand", f.Flavor "Flavor", f.PKG_Comp "Component", f.Bottle_Size "Size", f.Facility "Facility", f.NPPM, f.SCADMIN FROM todo t, wsubwork w, FMSC_ATOWF f ,KUAF k WHERE t.SubWorkTask_Title = 'CS PM' and k.id=f.NPPM and w.subwork_subworkid = t.work_workid and w.subwork_subworkid = f.volumeid and t.work_workid = f.volumeid and f.versionnum = -1 and w.subwork_status != -1 ORDER BY t.subworktask_performerid_Name, t.subworktask_dateready If this ain't working then there's John,and there's Lindsay...
Mary_Slane_Corona
That works, I may try to tweak it a little more because there is another one that I need to convert from the kauf.id as well (SCADMIN).Thank you so much for your help.Mary
