Getting Workflow Attribute Names for a Live Report ? 1

[ibos01]

Hi All

Currently I am doing a live report that needs to get attributes of a workflow. I know that you can get the values of the attributes in the WFAttrData and WFAttrVersions but not the names. I also found that the WData table has data on the name but it needs to be parsed out and is tedious and make the query inefficient. I was wondering is there a table i missed or built-in function that is provided that would retrieve the name. Also though knowledge center links would be good i do not have access to it yet and don't know when i will.

Thanks
Igor

 

[appnair]

typically the definitions for such are stored in a file as a data structure sql tool cannot get these easily for this usually one resorts to supported api's.in many organisations such as ours we create support tables using oscript based on these definitions so people can make these ad hoc queries easily as you want.We normalize category definitions this way I am pretty sure the attribute is part of the map definition as such you will find that info when you export the map as XML,many SQL tools know how to parse XML so that may be another option.

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