Database view - how to link sc_task and sc_req_item for survey

[Vladi1]

I am trying to create database view for surveys. I need to add catalog task table to the view and I need help with "Where Clause". Catalog task is needed to show "assignment group" and "assigned to".

Any advice is much appreciated.

[rlatorre]

ct_request_item = ri_sys_id

[Vladi1]

Thank you for the reply. Unfortunately it does not work. It could be related to our settings...

Where clause in view u_catalog_task_survey_detail_vlady has an invalid field or a field that is not visible (ct_request_item)

[rlatorre]

What reference field on the sc_task table is the parent item (sc_req_item) stored on your instance?

[Vladi1 · Accepted solution]

thank you very much for you help. I added "parent" field to sc_task table and setup "Where Clause" to read ct_parent= ri_sys_id