| || |
Workflow cross table update
I have a problem.
I have the two fields RN_USER_01 and TC_USER_01.
Whenever the field RN_USER_01 is edited in the ManualRunner dialog, I want the entered value to be applied to TC_USER_01 for the TestInstance being run.
I have located the correct trigger sub for the field change, but I don't know how to write a value to a particular line in a different table.
If I could use SQL, this would be the sort of statement:
SET TC_USER_01 = RN_USER_01 WHERE RN_TEST_INSTANCE = TC_TEST_INSTANCE
Any help would be greatly appreciated.
Re: Workflow cross table update
You can use SQL with the .command object. Or, the object way of doing it would be to get a reference to the TSTest from the TSTestfactory. Then update the field on the TSTest object and post the changes.