Interviewer Reporting

@kfayer7 - 

This should give you the results (do go through the comments in the query to modify date range):

SELECT
feedback_template_id,
feedback_template_name,
feedback_type,
id,
requester_email,
requester_name,
reviewer_email,
reviewer_name,
profile_id,
position_id,
feedback.question_id,
feedback.label,
feedback.answer,
feedback.other_option,
feedback.comment
FROM 
***COMPANY***_profile_feedback fb,  fb.feedback_json.feedback as feedback AT index

where 
-- We are filtering for only those feedbacks which have been submitted using the condition below
status = 'SUBMITTED'

and feedback_type IN ('quick_feedback','interview_feedback')

-- Change the feedback submitted date here 
and created_at >= '2024-01-01'

Please let me know if you have further questions.