取QA收集要素字段

查看收集计划下面收集要素后台对应的字段

 

SELECT qpc.result_column_name

,qc.name

,qc.prompt

 

FROM qa_plans qp

,qa_chars qc

,qa_plan_chars qpc

WHERE qp.name = 'TEST-收集计划'

AND qp.plan_id = qpc.plan_id

AND qc.char_id = qpc.char_id

AND qc.name = p_char_name;