Livereport autotracking w/a Workflow Form

MyLivelink_Users_(JTASCUser2_(Delete)_1425261)

Is it possible to create an autotracking feature that will display in a Livereport when you have multiple intances of a form passing through a workflow, and you are tracking this form's attributes throughout this workflow?I've used the SEQ attribute and this works well when you want to query a form's attribute after submittal, but when a workflow is involved and there are say 5 user steps in this workflow, then the livereport's SEQ attribute is all out of wack. If I have to create a seperate report for the last step, that's okay, but I would like to know if I can write some code within this sql statement to display a tracking mechanism, such as 001, 002, etc.Please help,Thanks,Jon

Find more posts tagged with

Comments

x-unileveruser11_-_(deleted)

If you are just after the current values then you can look at the WFFORMS table which stores the Master Form data, if you want each version, check out the versions table and then you should be able to use the extrac column data in there to link each version to a workflow step. Let me know if you need more.

MyLivelink_Users_(JTASCUser2_(Delete)_1425261)

Hello Greg!I don't know where to start. Where does the Webforms table reside and how would I go about displaying the current attributes from a form in a livereport that is being routed throughout a workflow.Which version of Livelink will support this? We have 2 versions, 9.0 and 9.1.Thanks for your response.Jon

x-unileveruser11_-_(deleted)

Jon,The workflow forms table are stored in the WFFORMS table, with versions stored in WFFORMSVERSIONS. If you speak to your Account Manager you can get a copy of the Schema and then do the course that OT provide.