Hi! I have added some new user defined fields to the Test Plan area with the intention that they will store the Test Case's location with the Test Plan Tree.

So the tree looks something like this:

-> System
-> Grouping
-> SubSystem
-> Category
-> Feature_1
-> Feature_2
-> Feature_3

The new user defined fields are System, SubSystem, Category, Feature_1, Feature_2, Feature_3.

The intention was that the Test Case writers would fill in these fields manually to allow us to extract particular sets of Test Cases using a Query.

My Manager has now asked me if these fields can be filled in automatically.

Using the Workflow I have already customised the Field Order on screen and using the Report Generator I have worked out some of the SQL I would need to extract the Folder Names.

What I want to know is can I use SQL within the Workflow and then Set the Field Values based on the result returned?

There is also a slight issue in that all Folders will be used down to Feature_1 but the Test Case maybe stored within either Feature_1, 2, or 3. So I guess I would need to walk up the tree to Category (this can only be either "Functional", "Non-Functional" or "Regression") and check from there.

What are your thoughts?

Many thanks in advance for any help you can give me.