SQL Call for Workflow Attribute Values

Marc_Minnies

The data I need to extract is stored in the WFAttrData table under WF_VALLONG, WF_ATTRID = 9, WF_ATTRTYPE = 11 and WF_ENTRYNUM = 1 (what does the "1" stand for? First pass through workflow?). What SQL call will pull this information? Any information is appreciated!

eLink User

Message from Alex Kowalenko via eLinkYou need a primer on how the WFAttrData table is used to store WFattributes.WFAttrData has several columns that can be grouped into 3 types:1. WF relationshipWF_ID - SubWorkflow ID used to link this data to a specific workflow definedin WWork and WSubWork tables.2. Attribute identificationWF_AttrID - a number that uniquely identifies the workflow attribute.WF_AttrType - an attribute type code (11 = multiline text, -1 = text, 2 =integer, -7 = date, etc)WF_EntryNum - multiple value index. if WF_EntryNum = 1 this means the firstof one or of many values for this attribute; note that attributes can havemultiple values.3. Attribute valueWF_ValDate - date (attrtypes -7 and 13)WF_ValInt - integer (attrypes 2, 5, 12 and 14)WF_ValLong - long text (attrtype 11)WF_ValReal - real (attrtype -4 and 20)WF_ValStr - text (attrtype -1 and 10)Here is an SQL example to get two attribute values for all workflows thatbelong to a specific user:SELECT SubWork_Title, /* workflow title */ Work_Status, /* workflow status */ a1.WF_ValLong /* 1st attribute value */ a2.WF_ValText /* 2nd attribute value */ FROM WWork, /* main workflow */ WSubWork, /* subworkflow */ WF_AttrData a1, /* 1st attribute */ WF_AttrData a2 /* 2nd attribute */ WHERE SubWork_WorkID = Work_WorkID and /* subworkflow-workflow reln */ a1.WF_ID = SubWork_SubWorkID and /* 1st attribute-subworkflow reln */ a1.WF_AttrID = 9 and /* 1st WF attribute is #9 */ a1.WF_EntryNum = 1 and /* 1st attribute value #1 */ a2.WF_ID = SubWork_SubWorkID and /* 2nd attribute-subworkflow reln */ a2.WF_AttrID = 5 and /* 2nd WF attribute is #5 */ a2.WF_EntryNum = 1 and /* 2nd attribute value #1 */ Work_OwnerID = %1 /* LiveReport user type input parameter*/There is another table, called WFAttrDataVersions, that stores attributevalues for each workflow task. It has the same columns as WFAttrData plustwo more identification columns, called WF_SubWorkID and WF_TaskID, thatrelate to WSubWork and SubWorkTask respectively.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, May 16, 2002 12:41To: eLink RecipientSubject: SQL Call for Workflow Attribute ValuesSQL Call for Workflow Attribute ValuesPosted by LMJSFAdmin on 05/16/2002 12:38 PMThe data I need to extract is stored in the WFAttrData table underWF_VALLONG, WF_ATTRID = 9, WF_ATTRTYPE = 11 and WF_ENTRYNUM = 1 (what does the "1" stand for? First pass through workflow?). What SQL call will pull this information? Any information is appreciated![To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe