Estimated execution time

[tbennett]

I've added the custom fields CF_ESTIMATED_EXEC_TIME and CF_EXEC_TIME (as an different post explained how to do).

These seem to work well, but with limited functionality.

I'd like to query the database directly, and get a total of the estimated execution time for a TestPlan or Build.

My problem is I can't figure out how, in the database, the estimated times related to the test cases.

I see the estimated times are stored in cfield_design_values -- but how does this table link to test cases, or testPlans?

[fman]

because you do not know how to query DB for this value this does not means feature is limited.

node_id in cfield* tables when custom field is used on a test case holds test case id.

You need to get field_id from custom field definition table

[tbennett]

What I meant by 'limited functionality' is there is no way in the TestLink GUI to get a total of estimated time for a test plan, for example.

But aside from that, I still can't figure out which tables contain the information I'm looking for. I've got the field_id, so from that I've got node_id. But how does the value of node_id link to any other table?

Example: in cfield_design_values,
node_id=8375
value=13
How can I figure out which test case (taking 13 minutes) corresponds to 8375?

[fman]

Reports display SUM() of these two special Custom fields, enabled ALL options when requesting report.

[JohnE]

Sorry, which report do you mean will provide the SUM() of these two times?

I have tried all of the default reports, e.g. Test Report, and I do not see and Total. Where is this located, please?

[tbennett]

At the very bottom of the Test Report, with Metrics and Custom Fields selected.