1,当日执行了哪些案例
2,执行结果
3,执行次数
于是乎,找了个时间对TD的数据库进行了分析,结果发现test表中的ts_subject列,找不到其对应的父表,没办法,找google帮忙了,搜索一番,找到下面这个sql:
SELECT
td.ALL_LISTS.AL_DESCRIPTION AS Subject,
td.TEST.TS_NAME AS Name,
td.TEST.TS_STATUS AS Status,
td.TEST.TS_CREATION_DATE AS [Creation Date],
td.TEST.TS_DESCRIPTION AS [Test Description],
td.DESSTEPS.DS_STEP_NAME AS [Step No.],
td.DESSTEPS.DS_DESCRIPTION AS [Step Description],
td.DESSTEPS.DS_EXPECTED AS [Expected Results]
FROM td.ALL_LISTS INNER JOIN
td.TEST ON td.ALL_LISTS.AL_ITEM_ID = td.TEST.TS_SUBJECT INNER JOIN
td.DESSTEPS ON td.TEST.TS_TEST_ID = td.DESSTEPS.DS_TEST_ID
ORDER BY td.ALL_LISTS.AL_DESCRIPTION, td.TEST.TS_NAME, td.DESSTEPS.DS_STEP_ORDER
可以从sql中分析出字段的关系了,成功踏出了第一步。