Execute the following query and save the results as an Excel file. Upload that file below. select wf.name, wi.user_name, wi.date_created, wi.date_changed, wfrm.name form, we.java_handler type, wfrme.unique_name element, wfrme.sequence_nr, wfrme.element_data, wc.content_data, wc.draft_ind, wc.completed_ind, wc.date_changed lastChanged, (select listagg(unique_name, '') from wt_edit_by wtedt left join wt_form_element wtfrmedit on wtfrmedit.form_element_id=wtedt.role_form_element_id where wtedt.edit_form_element_id=wfrme.form_element_id) edit_by from wt_flow wf left join wt_form wfrm on wfrm.flow_content_pk1 = wf.flow_content_pk1 left join wt_form_element wfrme on wfrme.form_content_pk1 = wfrm.form_content_pk1 left join wt_element we on wfrme.element_id = we.element_id left join wt_flow_instance wi on wi.flow_content_pk1 = wf.flow_content_pk1 left join wt_content wc on wc.flow_instance_id = wi.flow_instance_id and wc.form_element_id=wfrme.form_element_id where wf.course_pk1=xxxx -- and wi.user_name='yyyy' order by wi.user_name, wfrm.form_content_pk1, wfrme.sequence_nr;
select wf.name, wi.user_name, wi.date_created, wi.date_changed, wfrm.name form, we.java_handler type, wfrme.unique_name element, wfrme.sequence_nr, wfrme.element_data, wc.content_data, wc.draft_ind, wc.completed_ind, wc.date_changed lastChanged, (select listagg(unique_name, '') from wt_edit_by wtedt left join wt_form_element wtfrmedit on wtfrmedit.form_element_id=wtedt.role_form_element_id where wtedt.edit_form_element_id=wfrme.form_element_id) edit_by from wt_flow wf left join wt_form wfrm on wfrm.flow_content_pk1 = wf.flow_content_pk1 left join wt_form_element wfrme on wfrme.form_content_pk1 = wfrm.form_content_pk1 left join wt_element we on wfrme.element_id = we.element_id left join wt_flow_instance wi on wi.flow_content_pk1 = wf.flow_content_pk1 left join wt_content wc on wc.flow_instance_id = wi.flow_instance_id and wc.form_element_id=wfrme.form_element_id where wf.course_pk1=xxxx -- and wi.user_name='yyyy' order by wi.user_name, wfrm.form_content_pk1, wfrme.sequence_nr;