{"22":{"request":{"url":"/position","get":{"id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"id":"2233785415505431562","org_id":"2233785415505268868","city_id":"1801439851226622099","cities":{"id":"1801439851226622099","name":"A'ablin"},"address":"er","department_id":"2233785415505282005","departments":{"id":"2233785415505282005","name":"dep"},"coordinator_id":"2233785415505288313","coordinators":{"id":"2233785415505288313","enabled":true,"hidden":false,"name":"coord"},"cluster_id":null,"clusters":null,"single":false,"cap":10,"begin_dt":1452132000,"accepted_candidates":1,"sla":0,"status_id":"1801439851249186875","position_statuses":{"id":"1801439851249186875","symbolic_name":"active","name":"Active"},"reason_id":null,"position_reasons":null,"position_id":1111111111112,"has_course":true,"name":"gr_ec","description":"e"},"messages":[{"success":true}]},"httpCode":200}},"23":{"request":{"url":"/position/steps","get":{"position_id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":[{"id":"2233785415505444232","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":1,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"ST1","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505444256","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q","metric_name":null,"question_variants":[]},{"id":"2233785415505444268","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q2","metric_name":null,"question_variants":[]},{"id":"2233785415505444283","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q3","metric_name":null,"question_variants":[]}]},{"id":"2233785415505447153","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":2,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"C","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505447165","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505447153","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"g","metric_name":null,"question_variants":[]}]},{"id":"2233785415505444220","tag_id":null,"position_step_tags":null,"index":3,"position_id":"2233785415505431562","type_id":"1801439851258404539","steps":{"id":"1801439851258404539","symbolic_name":"group","name":"Group"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"GR","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]},{"id":"2233785415505447107","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":5,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"st2","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505447131","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505447107","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"d","metric_name":null,"question_variants":[]}]},{"id":"2233785415505447119","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":6,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"st3","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]},{"id":"2233785415505444450","tag_id":null,"position_step_tags":null,"index":7,"position_id":"2233785415505431562","type_id":"1801439851258404509","steps":{"id":"1801439851258404509","symbolic_name":"evaluation_center","name":"Evaluation Center"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"EC","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505444462","type_id":"1801439851239420758","question_types":{"id":"1801439851239420758","symbolic_name":"rate","name":"Rating"},"questionnaire_id":null,"position_step_id":"2233785415505444450","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"e","metric_name":null,"question_variants":[{"id":"2233785415505444474","question_id":"2233785415505444462","sort_order":0,"title":"w2"}]}]},{"id":"2233785415505431587","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":1000000000,"position_id":"2233785415505431562","type_id":"1801439851259050299","steps":{"id":"1801439851259050299","symbolic_name":"sign","name":"Sign"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"Sign","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]}],"messages":[{"success":true}]},"httpCode":200}},"24":{"request":{"url":"/position/event","get":{"position_id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"course_event":[{"id":"2233785415512353446","is_course":true,"hidden":false,"time_start":1452211200,"time_end":1452297600,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"h","city_id":"1801439851226620412","cities":{"id":"1801439851226620412","name":"Alfey Menashe"},"name":"GRECCourse","cap":44,"real_cap":44,"candidates_count":0,"pending_candidates":2,"accepted_candidates":0,"pending_candidates_count":2,"self_sent_candidates_count":0,"position_id":"2233785415505431562"},{"id":"2233785415512048822","is_course":true,"hidden":false,"time_start":1449792000,"time_end":1452132000,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"d","city_id":"1801439851227612502","cities":{"id":"1801439851227612502","name":"Adamit"},"name":"NewCourse","cap":10,"real_cap":10,"candidates_count":1,"pending_candidates":24,"accepted_candidates":1,"pending_candidates_count":24,"self_sent_candidates_count":0,"position_id":"2233785415505431562"},{"id":"2233785415506924867","is_course":true,"hidden":false,"time_start":1444089600,"time_end":1444176000,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"d","city_id":"1801439851226246321","cities":{"id":"1801439851226246321","name":"Adi"},"name":"aTest","cap":4,"real_cap":4,"candidates_count":0,"pending_candidates":0,"accepted_candidates":0,"pending_candidates_count":0,"self_sent_candidates_count":0,"position_id":"2233785415505431562"}],"ec_event":[{"id":"2233785415512351428","is_course":false,"hidden":false,"time_start":1451545200,"time_end":1451559600,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"g","city_id":"1801439851255026259","cities":{"id":"1801439851255026259","name":"Almagor"},"name":"GGGRRR","cap":67,"real_cap":0,"candidates_count":3,"pending_candidates":0,"accepted_candidates":3,"pending_candidates_count":0,"self_sent_candidates_count":1,"position_id":"2233785415505431562"}]},"messages":[{"success":true}]},"httpCode":200}},"25":{"request":{"url":"/position","get":{"id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"id":"2233785415505431562","org_id":"2233785415505268868","city_id":"1801439851226622099","cities":{"id":"1801439851226622099","name":"A'ablin"},"address":"er","department_id":"2233785415505282005","departments":{"id":"2233785415505282005","name":"dep"},"coordinator_id":"2233785415505288313","coordinators":{"id":"2233785415505288313","enabled":true,"hidden":false,"name":"coord"},"cluster_id":null,"clusters":null,"single":false,"cap":10,"begin_dt":1452132000,"accepted_candidates":1,"sla":0,"status_id":"1801439851249186875","position_statuses":{"id":"1801439851249186875","symbolic_name":"active","name":"Active"},"reason_id":null,"position_reasons":null,"position_id":1111111111112,"has_course":true,"name":"gr_ec","description":"e"},"messages":[{"success":true}]},"httpCode":200}},"26":{"request":{"url":"/position/steps","get":{"position_id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":[{"id":"2233785415505444232","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":1,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"ST1","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505444256","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q","metric_name":null,"question_variants":[]},{"id":"2233785415505444268","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q2","metric_name":null,"question_variants":[]},{"id":"2233785415505444283","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505444232","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"q3","metric_name":null,"question_variants":[]}]},{"id":"2233785415505447153","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":2,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"C","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505447165","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505447153","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"g","metric_name":null,"question_variants":[]}]},{"id":"2233785415505444220","tag_id":null,"position_step_tags":null,"index":3,"position_id":"2233785415505431562","type_id":"1801439851258404539","steps":{"id":"1801439851258404539","symbolic_name":"group","name":"Group"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"GR","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]},{"id":"2233785415505447107","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":5,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"st2","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505447131","type_id":"1801439851239420467","question_types":{"id":"1801439851239420467","symbolic_name":"free","name":"Free Text"},"questionnaire_id":null,"position_step_id":"2233785415505447107","position_id":"2233785415505431562","index":"1","mandatory":false,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"d","metric_name":null,"question_variants":[]}]},{"id":"2233785415505447119","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":6,"position_id":"2233785415505431562","type_id":"1801439851258404389","steps":{"id":"1801439851258404389","symbolic_name":"generic","name":"Generic"},"questionnaire_id":null,"group_id":"2233785415505444220","send_rejection_email":false,"name":"st3","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]},{"id":"2233785415505444450","tag_id":null,"position_step_tags":null,"index":7,"position_id":"2233785415505431562","type_id":"1801439851258404509","steps":{"id":"1801439851258404509","symbolic_name":"evaluation_center","name":"Evaluation Center"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"EC","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[{"id":"2233785415505444462","type_id":"1801439851239420758","question_types":{"id":"1801439851239420758","symbolic_name":"rate","name":"Rating"},"questionnaire_id":null,"position_step_id":"2233785415505444450","position_id":"2233785415505431562","index":"1","mandatory":true,"use_in_report":false,"metric_id":null,"question_metric_types":null,"metric_format":"string","description":"e","metric_name":null,"question_variants":[{"id":"2233785415505444474","question_id":"2233785415505444462","sort_order":0,"title":"w2"}]}]},{"id":"2233785415505431587","tag_id":"2233785415505359258","position_step_tags":{"id":"2233785415505359258","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":1000000000,"position_id":"2233785415505431562","type_id":"1801439851259050299","steps":{"id":"1801439851259050299","symbolic_name":"sign","name":"Sign"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"Sign","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]}],"messages":[{"success":true}]},"httpCode":200}},"27":{"request":{"url":"/position/event","get":{"position_id":"2233785415505431562","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"course_event":[{"id":"2233785415512353446","is_course":true,"hidden":false,"time_start":1452211200,"time_end":1452297600,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"h","city_id":"1801439851226620412","cities":{"id":"1801439851226620412","name":"Alfey Menashe"},"name":"GRECCourse","cap":44,"real_cap":44,"candidates_count":0,"pending_candidates":2,"accepted_candidates":0,"pending_candidates_count":2,"self_sent_candidates_count":0,"position_id":"2233785415505431562"},{"id":"2233785415512048822","is_course":true,"hidden":false,"time_start":1449792000,"time_end":1452132000,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"d","city_id":"1801439851227612502","cities":{"id":"1801439851227612502","name":"Adamit"},"name":"NewCourse","cap":10,"real_cap":10,"candidates_count":1,"pending_candidates":24,"accepted_candidates":1,"pending_candidates_count":24,"self_sent_candidates_count":0,"position_id":"2233785415505431562"},{"id":"2233785415506924867","is_course":true,"hidden":false,"time_start":1444089600,"time_end":1444176000,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"d","city_id":"1801439851226246321","cities":{"id":"1801439851226246321","name":"Adi"},"name":"aTest","cap":4,"real_cap":4,"candidates_count":0,"pending_candidates":0,"accepted_candidates":0,"pending_candidates_count":0,"self_sent_candidates_count":0,"position_id":"2233785415505431562"}],"ec_event":[{"id":"2233785415512351428","is_course":false,"hidden":false,"time_start":1451545200,"time_end":1451559600,"instructor_id":"2233785415505288481","instructors":{"id":"2233785415505288481","enabled":true,"hidden":false,"name":"instructor"},"all_day":false,"address":"g","city_id":"1801439851255026259","cities":{"id":"1801439851255026259","name":"Almagor"},"name":"GGGRRR","cap":67,"real_cap":0,"candidates_count":3,"pending_candidates":0,"accepted_candidates":3,"pending_candidates_count":0,"self_sent_candidates_count":1,"position_id":"2233785415505431562"}]},"messages":[{"success":true}]},"httpCode":200}},"28":{"request":{"url":"/position/candidates","get":{"position_id":"2233785415505431562","step_id":"2233785415505444232","org_id":"2233785415505268868","csrf":"a68dd7c2ef5dd609cde13bc47c2be738"},"post":{},"requestMethod":"GET"},"response":{"data":{"messages":[{"success":false},{"error":"PGSQL_EMPTY_QUERY\nERROR:  column cvs.update_dt does not exist\nLINE 2:  cvs.update_dt as cvs_update_dt,\n         ^\nselect distinct on (cln_candidates.id, cln_candidates.dt) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value\n from ct_candidate_positions candidate_positions\ninner join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id)\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\nleft join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\n where  ( position_steps.id = '2233785415505444232' )\n and  candidate_positions.ct_global_status_id != '1801439851258840040' and  ( candidate_positions.ct_cln_position_id = '2233785415505431562' )\n and  candidate_steps.ct_cln_event_id is null\norder by cln_candidates.dt desc","traces":[{"file":"/var/www/erp_synergy/core/db.php","line":103,"function":"exec","class":"ErrorThrowDatabase","type":"->","args":["select distinct on (cln_candidates.id, cln_candidates.dt) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value\n from ct_candidate_positions candidate_positions\ninner join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id)\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\nleft join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\n where  ( position_steps.id = '2233785415505444232' )\n and  candidate_positions.ct_global_status_id != '1801439851258840040' and  ( candidate_positions.ct_cln_position_id = '2233785415505431562' )\n and  candidate_steps.ct_cln_event_id is null\norder by cln_candidates.dt desc"]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Db.php","line":166,"function":"execute","class":"Database","type":"->","args":["select distinct on (cln_candidates.id, cln_candidates.dt) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value\n from ct_candidate_positions candidate_positions\ninner join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id)\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\nleft join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\n where  ( position_steps.id = '2233785415505444232' )\n and  candidate_positions.ct_global_status_id != '1801439851258840040' and  ( candidate_positions.ct_cln_position_id = '2233785415505431562' )\n and  candidate_steps.ct_cln_event_id is null\norder by cln_candidates.dt desc"]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":902,"function":"getAll","class":"Callnet\\Db","type":"::","args":["select distinct on (cln_candidates.id, cln_candidates.dt) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value\n from ct_candidate_positions candidate_positions\ninner join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id)\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\nleft join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\n where  ( position_steps.id = '2233785415505444232' )\n and  candidate_positions.ct_global_status_id != '1801439851258840040' and  ( candidate_positions.ct_cln_position_id = '2233785415505431562' )\n and  candidate_steps.ct_cln_event_id is null\norder by cln_candidates.dt desc"]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":959,"function":"fetchRawData","class":"Callnet\\Concept\\Base","type":"->","args":[0,1,null,null]},{"function":"Callnet\\Concept\\{closure}","class":"Callnet\\Concept\\Base","type":"->","args":[]},{"file":"/var/www/callnetapi.am-test.com/application/classes/StaticCache.php","line":25,"function":"call_user_func","args":[{}]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":973,"function":"get","class":"Callnet\\StaticCache","type":"::","args":["Callnet\\Concept\\Base::getDataFromMc_getData_c5e54bfb10a7cf5e7109eca67c608b3a1af05130",{}]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":1030,"function":"getDataFromMc","class":"Callnet\\Concept\\Base","type":"->","args":["fetchRawData","getData",0,1,null,null]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":959,"function":"getData","class":"Callnet\\Concept\\Base","type":"->","args":[0,1,null,null]},{"function":"Callnet\\Concept\\{closure}","class":"Callnet\\Concept\\Base","type":"->","args":[]},{"file":"/var/www/callnetapi.am-test.com/application/classes/StaticCache.php","line":25,"function":"call_user_func","args":[{}]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":973,"function":"get","class":"Callnet\\StaticCache","type":"::","args":["Callnet\\Concept\\Base::getDataFromMc_getMergeData_c5e54bfb10a7cf5e7109eca67c608b3a1af05130",{}]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":1152,"function":"getDataFromMc","class":"Callnet\\Concept\\Base","type":"->","args":["getData","getMergeData",0,1,1,0]},{"file":"/var/www/callnetapi.am-test.com/application/classes/Concept/Base.php","line":1209,"function":"getConceptData","class":"Callnet\\Concept\\Base","type":"->","args":[0,1,1,0]},{"file":"/var/www/callnetapi.am-test.com/application/controllers/PositionController.php","line":65,"function":"getConcept","class":"Callnet\\Concept\\Base","type":"->","args":[]},{"function":"candidatesAction","class":"Callnet\\PositionController","type":"->","args":[]},{"file":"/var/www/erp_synergy/core/BaseController.php","line":87,"function":"call_user_func","args":[[{},"candidatesAction"]]},{"file":"/var/www/erp_synergy/core/Application.php","line":167,"function":"invokeAction","class":"ERP_Core_BaseController","type":"->","args":["candidates"]},{"file":"/var/www/erp_synergy/core/Application.php","line":59,"function":"processURI","class":"ERP_Core_Application","type":"->","args":[]},{"file":"/var/www/callnetapi.am-test.com/api.php","line":7,"function":"run","class":"ERP_Core_Application","type":"->","args":[]}]}]},"httpCode":500}}}