Getting Attribute Name for Workflow Attributes

[karthikeyanks]

Hi All,

I am trying to get the Attribute Name and value for the workflow. I was able to find the values in WFAttrData and WFAttrVersions table. But I am not able to find the corresponding Attribute Name for values in these table.

Could you please let me know, which table contains the Attribute Names for the Workflow attributes?

Thank You
KSK

 

[appnair]

As I posted recently to a similar query in the KB, the WF attributes even though it looks very similar to category/Attributes the definitions are not stored in a table.Livelink uses code to parse the WF map definition-The definition is just a flat file -stored in the filestore-EFS,SQL or Archive server as the case maybe.If you export a workflow map and open it up with notepad++ or Textpad you can see the proprietary data structure.This has all info about the WF map which is used to create those names in the table.Mostly people will use a programming language capable of deciphering that logic(Oscript,LAPI or SOAP) .If this is a small project I would just hard code the info or if it is a re-usable attempt I would use a programming language and turn that into lookup tables.Sionce this is a very common request just like catregionamp gives you info about cats/atts you can ask OT to provide a sqlfriendly feature as well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in