Workflow tasks

[sallada]

Hello,

I want to run some queries on the SoftPro database and retrieve the names of all the various workflow tasks set up. What tables should I use?

Thanks.

[Melissa McBerkowitz]

In Cameron, the tasks within an order are stored in pfm.Task and pfm.RequestedTask. These two tables are the equivalent of Boylan's dbo.OrderTask and dbo.RequestedOrderTask tables.

The tasks defined for a given workflow step in SPAdmin are in pf.WorkflowTask. This is just the workflow definition of tasks - when an order actually goes through the workflow, corresponding tasks are created within the order and stored in the pfm tables referenced above.