WF_AttrType

Thomas_Shacklee_(aberuser12_-_(deleted))

Does anybody know the type of the workflow attribute is when WF_AttrType = 14?Thanks,Susan susan.****@atec.army.mil

Find more posts tagged with

Comments

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

According to this info posted else-where in these discussions, 14 is stored as an Integer --I believe it is a User attribute, and stores a user ID.

Here is some information I found from a discussion somewhere (can't remember... Posted by bsingh (Singh, Bhupinder) on 07/23/2002 01:12 PM In reply to: RE RE Show in Search feature Posted by eLink on 07/23/2002 12:34 PM
Here is some information I found from a discussion somewhere (can't remember where), submitted by Alex Kowalenko of Open Text:

You need a primer on how the WFAttrData table is used to store WF attributes.

WFAttrData has several columns that can be grouped into 3 types:

1. WF relationship

WF_ID - SubWorkflow ID used to link this data to a specific workflow defined in WWork and WSubWork tables.

2. Attribute identification

WF_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 first of one or of many values for this attribute; note that attributes can have multiple values.

3. Attribute value

WF_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 that belong 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 attribute values for each workflow task. It has the same columns as WFAttrData plus two more identification columns, called WF_SubWorkID and WF_TaskID, that relate to WSubWork and SubWorkTask respectively.

-alex-

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, September 17, 2003 1:06
To: eLink Recipient

WF_AttrType

Posted by AberUser12 on 09/17/2003 12:55 PM

Does anybody know the type of the workflow attribute is when WF_AttrType = 14?

Thanks,

Susan
susan.****@atec.army.mil

Thomas_Shacklee_(aberuser12_-_(deleted))

It is very helpful. Thank you!Susan