{"23":{"request":{"url":"/org_dict/clusters","get":{"org_id":"1801439851237913898","csrf":"525689d2e64f8baaaa83e8f94fcf61d4"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":[{"id":"1801439851256122552","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"Positions cluster 4x4","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258869592","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"The Very Best CV Sources","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258872166","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"Dep444","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258872186","cluster_id":"1801439851258872166","department_id":"1801439851252456342","departments":{"id":"1801439851252456342","enabled":true,"name":"חטיבת מכירות"}},{"id":"1801439851258872188","cluster_id":"1801439851258872166","department_id":"1801439851252469831","departments":{"id":"1801439851252469831","enabled":true,"name":"חטיבת מכירות"}},{"id":"1801439851258872194","cluster_id":"1801439851258872166","department_id":"1801439851252456342","departments":{"id":"1801439851252456342","enabled":true,"name":"חטיבת מכירות"}}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258872291","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"Dep55","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258885158","cluster_id":"1801439851258872291","department_id":"1801439851252288987","departments":{"id":"1801439851252288987","enabled":true,"name":"חטיבת משאבי אנוש"}},{"id":"1801439851258885160","cluster_id":"1801439851258872291","department_id":"1801439851252456342","departments":{"id":"1801439851252456342","enabled":true,"name":"חטיבת מכירות"}},{"id":"1801439851258885162","cluster_id":"1801439851258872291","department_id":"1801439851252466341","departments":{"id":"1801439851252466341","enabled":true,"name":"חטיבת שירות לקוחות"}},{"id":"1801439851258885164","cluster_id":"1801439851258872291","department_id":"1801439851252468260","departments":null},{"id":"1801439851258885166","cluster_id":"1801439851258872291","department_id":"1801439851252469831","departments":{"id":"1801439851252469831","enabled":true,"name":"חטיבת מכירות"}},{"id":"1801439851258931417","cluster_id":"1801439851258872291","department_id":"1801439851252290408","departments":null}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258885255","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"אזור המרכז","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[{"id":"1801439851267682459","cluster_id":"1801439851258885255","city_id":"1801439851226616003","cities":{"id":"1801439851226616003","name":"Or Yehuda"}},{"id":"1801439851267682461","cluster_id":"1801439851258885255","city_id":"1801439851227613258","cities":{"id":"1801439851227613258","name":"Bareket"}},{"id":"1801439851267682463","cluster_id":"1801439851258885255","city_id":"1801439851227012775","cities":null},{"id":"1801439851267682465","cluster_id":"1801439851258885255","city_id":"1801439851226164009","cities":{"id":"1801439851226164009","name":"Bat Yam"}},{"id":"1801439851267682467","cluster_id":"1801439851258885255","city_id":"1801439851244342774","cities":null},{"id":"1801439851267682469","cluster_id":"1801439851258885255","city_id":"1801439851227613482","cities":{"id":"1801439851227613482","name":"Givat Shmuel"}},{"id":"1801439851267682471","cluster_id":"1801439851258885255","city_id":"1801439851227613797","cities":{"id":"1801439851227613797","name":"Ganey Tikva"}},{"id":"1801439851267682473","cluster_id":"1801439851258885255","city_id":"1801439851226228330","cities":{"id":"1801439851226228330","name":"Holon"}},{"id":"1801439851267682475","cluster_id":"1801439851258885255","city_id":"1801439851226161647","cities":{"id":"1801439851226161647","name":"Yehud"}},{"id":"1801439851267682477","cluster_id":"1801439851258885255","city_id":"1801439851227614910","cities":null},{"id":"1801439851267682479","cluster_id":"1801439851258885255","city_id":"1801439851249054828","cities":{"id":"1801439851249054828","name":"Rosh Ha'ain"}},{"id":"1801439851267682481","cluster_id":"1801439851258885255","city_id":"1801439851226432383","cities":{"id":"1801439851226432383","name":"Rishon Lezion"}},{"id":"1801439851267682483","cluster_id":"1801439851258885255","city_id":"1801439851227619055","cities":{"id":"1801439851227619055","name":"Shoham"}},{"id":"1801439851267682498","cluster_id":"1801439851258885255","city_id":"1801439851227613062","cities":{"id":"1801439851227613062","name":"Bnei Brak"}},{"id":"1801439851267682500","cluster_id":"1801439851258885255","city_id":"1801439851227616023","cities":{"id":"1801439851227616023","name":"Lod"}},{"id":"1801439851267682502","cluster_id":"1801439851258885255","city_id":"1801439851227617024","cities":{"id":"1801439851227617024","name":"Mishmar Hashivha"}},{"id":"1801439851267682504","cluster_id":"1801439851258885255","city_id":"1801439851226247977","cities":{"id":"1801439851226247977","name":"Ramla"}},{"id":"1801439851267682414","cluster_id":"1801439851258885255","city_id":"1801439851227613510","cities":{"id":"1801439851227613510","name":"Givattayim"}},{"id":"1801439851267682416","cluster_id":"1801439851258885255","city_id":"1801439851226242868","cities":{"id":"1801439851226242868","name":"Petah Tikva"}},{"id":"1801439851267682418","cluster_id":"1801439851258885255","city_id":"1801439851227618508","cities":{"id":"1801439851227618508","name":"Kiryat Ono"}},{"id":"1801439851267682420","cluster_id":"1801439851258885255","city_id":"1801439851267042739","cities":{"id":"1801439851267042739","name":"Ramat Aviv"}},{"id":"1801439851267682422","cluster_id":"1801439851258885255","city_id":"1801439851226163960","cities":{"id":"1801439851226163960","name":"Ramat Gan"}},{"id":"1801439851267682424","cluster_id":"1801439851258885255","city_id":"1801439851244229735","cities":null},{"id":"1801439851267682426","cluster_id":"1801439851258885255","city_id":"1801439851226148710","cities":{"id":"1801439851226148710","name":"Tel Aviv"}}]},{"id":"1801439851258921011","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"אזור חיפה והצפון","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258921126","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"ivan123","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258921138","cluster_id":"1801439851258921126","department_id":"1801439851252290408","departments":null}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258921142","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"ivan2","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258921152","cluster_id":"1801439851258921142","department_id":"1801439851252290408","departments":null}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258937383","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"ivan123","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258944185","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"testone","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258999593","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"new cluster","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258999607","cluster_id":"1801439851258999593","department_id":"1801439851252469831","departments":{"id":"1801439851252469831","enabled":true,"name":"חטיבת מכירות"}},{"id":"1801439851258999609","cluster_id":"1801439851258999593","department_id":"1801439851253080310","departments":{"id":"1801439851253080310","enabled":true,"name":"חטיבת תפעול אדמיניסטרציה"}}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851258999613","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"new2","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[{"id":"1801439851258999623","cluster_id":"1801439851258999613","department_id":"1801439851252982260","departments":{"id":"1801439851252982260","enabled":true,"name":"חטיבת תמיכה טכנית"}},{"id":"1801439851258999625","cluster_id":"1801439851258999613","department_id":"1801439851253080293","departments":{"id":"1801439851253080293","enabled":true,"name":"חטיבת שיווק"}},{"id":"1801439851258999627","cluster_id":"1801439851258999613","department_id":"1801439851253080310","departments":{"id":"1801439851253080310","enabled":true,"name":"חטיבת תפעול אדמיניסטרציה"}}],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851259429981","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"Testing1","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851268901115","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"אזור אילת","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[{"id":"1801439851268901127","cluster_id":"1801439851268901115","city_id":"1801439851226617607","cities":{"id":"1801439851226617607","name":"Eylot"}},{"id":"1801439851268901129","cluster_id":"1801439851268901115","city_id":"1801439851226431311","cities":{"id":"1801439851226431311","name":"Eilat"}},{"id":"1801439851268901131","cluster_id":"1801439851268901115","city_id":"1801439851226619234","cities":{"id":"1801439851226619234","name":"Elipaz"}},{"id":"1801439851268901133","cluster_id":"1801439851268901115","city_id":"1801439851227612586","cities":{"id":"1801439851227612586","name":"Beer Ora"}},{"id":"1801439851268901135","cluster_id":"1801439851268901115","city_id":"1801439851227614973","cities":{"id":"1801439851227614973","name":"Yotveta"}},{"id":"1801439851268901137","cluster_id":"1801439851268901115","city_id":"1801439851227617213","cities":{"id":"1801439851227617213","name":"Neve Harif"}},{"id":"1801439851268901139","cluster_id":"1801439851268901115","city_id":"1801439851227617703","cities":{"id":"1801439851227617703","name":"Samar"}}]},{"id":"1801439851268901205","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"חיפה והקריות","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851272550041","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TestRail","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851278892467","enabled":false,"hidden":true,"type_id":"1801439851257920705","cluster_types":{"id":"1801439851257920705","symbolic_name":"statuses","name":"Statuses"},"name":"St","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851279119056","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"Test","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851279422327","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"fl","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851279582994","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"VCS","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280047824","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"Test","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280048088","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"Test","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280048498","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"TestCV","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280054744","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"PosTest","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280056915","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"CVS","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280057031","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"CBCV","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280057252","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TestOne","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280081913","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"PositionCluster","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280082101","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"OnePos","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280082209","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"CVSource","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280082323","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"OneCV","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280145570","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"PosClus","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280145690","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"CVB","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280707347","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"TestCVV","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280707516","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TestR","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280730931","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"TesTWW","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280731048","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TestPos","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280731460","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"TestDep","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280749050","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"TestConsole","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280749832","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"VVV","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280754113","enabled":false,"hidden":true,"type_id":"1801439851256120364","cluster_types":{"id":"1801439851256120364","symbolic_name":"geographic","name":"Geographic"},"name":"BBBB","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280754792","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"GGGGGGGGG","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280756507","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"wwwww","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280756945","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"gguy","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280759057","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"ddddddd","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280760053","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"ddddd","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280762405","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"ggggggg","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280763301","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"OOOOOOOOOO","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280765776","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"A2222222222","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280766792","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TTTTTTTTTTTT","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280767240","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"EEEEEEEEE","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280768913","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"RRRRRRRRR","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280770821","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"eeeeeeeeee","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280771164","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"fgdgfd","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280772635","enabled":false,"hidden":true,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"AAAAAAAAA","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280782093","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"ccc","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280792102","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"TR","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851280792223","enabled":false,"hidden":true,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"TesTTTX","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851281331748","enabled":false,"hidden":true,"type_id":"1801439851256119934","cluster_types":{"id":"1801439851256119934","symbolic_name":"departments","name":"Departments"},"name":"VB","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851285952715","enabled":true,"hidden":false,"type_id":"1801439851256119860","cluster_types":{"id":"1801439851256119860","symbolic_name":"positions","name":"Positions"},"name":"TestPosition","cluster_positions":[{"id":"1801439851285952722","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952723","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952724","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952725","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952726","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952727","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952728","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952729","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952730","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952731","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952732","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952733","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952734","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952735","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952736","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952737","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952738","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952739","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952740","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952741","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952742","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952743","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952744","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952745","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952746","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952747","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952748","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952749","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952750","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952751","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952752","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952753","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952754","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952755","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952756","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952757","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952758","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952759","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952760","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952761","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952762","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952763","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952764","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952765","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952766","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952767","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952768","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952769","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952770","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952771","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952772","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952773","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952774","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952775","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952776","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952777","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952778","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952779","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952780","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952781","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952782","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952783","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952784","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952785","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952786","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952787","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952788","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952789","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952790","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952791","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952792","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952793","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952794","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952795","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952796","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952797","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952798","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952799","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952800","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952801","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952802","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952803","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952804","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952805","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952806","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952807","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952808","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952809","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952810","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952811","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952812","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952813","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952814","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952915","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952916","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952917","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952918","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952919","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952920","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952921","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952922","cluster_id":"1801439851285952715","position_id":null},{"id":"1801439851285952923","cluster_id":"1801439851285952715","position_id":null}],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[],"cluster_locations":[]},{"id":"1801439851285953067","enabled":true,"hidden":false,"type_id":"1801439851256120188","cluster_types":{"id":"1801439851256120188","symbolic_name":"cv_sources","name":"CV Sources"},"name":"Cv","cluster_positions":[],"cluster_statuses":[],"cluster_departments":[],"cluster_cv_sources":[{"id":"1801439851285953074","cluster_id":"1801439851285953067","cv_source_id":null,"cv_sources":null},{"id":"1801439851285953557","cluster_id":"1801439851285953067","cv_source_id":null,"cv_sources":null}],"cluster_locations":[]},["{{cmp}}","by_id_strict"]],"messages":[{"success":true}]},"httpCode":200}},"24":{"request":{"url":"/org_dict/candidate_reasons","get":{"org_id":"1801439851237913898","csrf":"525689d2e64f8baaaa83e8f94fcf61d4"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":[{"id":"1801439851238933884","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"הסיר מעומדות"},{"id":"1801439851248452005","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"מחכה לאישור"},{"id":"1801439851248452303","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"צריך לעבור מרכז הערכה"},{"id":"1801439851250601143","enabled":false,"symbolic_name":"new","hidden":true,"disabled":false,"name":"Auto-resume by reminder"},{"id":"1801439851251158413","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"מצא עבודה"},{"id":"1801439851251159415","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":true,"name":"ציפיות שכר"},{"id":"1801439851251159430","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"בירור מצב כספי"},{"id":"1801439851251160786","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"בבדיקה מול הלקוח"},{"id":"1801439851251161812","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"רוצה מכירות"},{"id":"1801439851252160008","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"רוצה שירות לקוחות"},{"id":"1801439851252160018","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"רוצה לחשוב"},{"id":"1801439851252472031","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"יצור קשר בעצמו"},{"id":"1801439851252472047","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"כושר ביטוי"},{"id":"1801439851253067111","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"מעוניין בתפקיד אחר"},{"id":"1801439851253067116","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"קשיחים"},{"id":"1801439851257383745","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"Call again twice"},{"id":"1801439851266461010","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"my_test"},{"id":"1801439851269897887","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"Failed the test"},{"id":"1801439851271267795","enabled":true,"symbolic_name":"pending","hidden":false,"disabled":false,"name":"ReasonAdvanced"},{"id":"1801439851271267833","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"ReasonAdvanced"},{"id":"1801439851272551111","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"Oneggf"},{"id":"1801439851273123755","enabled":true,"symbolic_name":"pending","hidden":false,"disabled":false,"name":"New Delhi"},{"id":"1801439851279468795","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"TestTTTT"},{"id":"1801439851279468921","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"TestReject"},{"id":"1801439851279469040","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"TestReject"},{"id":"1801439851279553706","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"ReasonForAdvanced"},{"id":"1801439851279716033","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"VBVB"},{"id":"1801439851279866488","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"ציפיות שכר"},{"id":"1801439851279866601","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"קשיחים"},{"id":"1801439851279866608","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"גיל"},{"id":"1801439851279866615","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"לא מעוניין"},{"id":"1801439851279866622","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"כושר ביטוי"},{"id":"1801439851279866629","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"הסיר מועמדות"},{"id":"1801439851280145019","enabled":true,"symbolic_name":"pending","hidden":false,"disabled":false,"name":"StorageC"},{"id":"1801439851280145246","enabled":true,"symbolic_name":"declined","hidden":false,"disabled":false,"name":"StorageV"},{"id":"1801439851280325423","enabled":true,"symbolic_name":"pending","hidden":false,"disabled":false,"name":"Test"},{"id":"1801439851280684608","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"TestPen"},{"id":"1801439851280684715","enabled":false,"symbolic_name":"declined","hidden":true,"disabled":false,"name":"RecRes"},{"id":"1801439851285944168","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":false,"name":"TerstTTXC"},{"id":"1801439851285950180","enabled":false,"symbolic_name":"pending","hidden":true,"disabled":true,"name":"TesTTX"},{"id":"1801439851285950982","enabled":false,"symbolic_name":"declined","hidden":false,"disabled":true,"name":"TestBugNew"},["{{cmp}}","by_id_strict"]],"messages":[{"success":true}]},"httpCode":200}},"25":{"request":{"url":"/report","get":{"id":"1801439851286127774","org_id":"1801439851237913898","csrf":"525689d2e64f8baaaa83e8f94fcf61d4"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"id":"1801439851286127774","type_id":"1801439851250353089","report_types":{"id":"1801439851250353089","symbolic_name":"raw","name":"Raw Data"},"funnel_type_id":"1801439851269656904","funnel_report_types":{"id":"1801439851269656904","symbolic_name":"single_position","name":"Single position"},"excel_type_id":"1801439851269649543","excel_report_types":{"id":"1801439851269649543","symbolic_name":"cv_sources_by_position","field1":"CV source","field2":"Position","name":"CV sources by position"},"position_step_tag_id":null,"position_step_tags":null,"template_id":"1801439851250356367","report_templates":{"id":"1801439851250356367","symbolic_name":"custom","report_type_id":"1801439851250353089","report_types":{"id":"1801439851250353089","symbolic_name":"raw","name":"Raw Data"},"name":"Custom report","preselected_metrics":[]},"date_interval_type_id":"1801439851279108495","date_interval_types":{"id":"1801439851279108495","symbolic_name":"all","name":"All"},"start_date":null,"end_date":null,"is_rejection_date":false,"compare":false,"compare_custom":false,"compare_start_date":null,"compare_end_date":null,"name":"VVVV","report_positions":[{"id":"1801439851286127781","report_id":"1801439851286127774","position_id":"1801439851285955895"},["{{cmp}}","by_id_strict"]],"report_statuses":[],"report_countries":[],"report_clusters":[],"report_cv_sources":[],"report_courses":[],"metrics":[{"id":"1801439851286127782","report_id":"1801439851286127774","metric_type_id":"1801439851280102093","metric_types":{"id":"1801439851280102093","editable":false,"sortable":true,"can_view_chart":true,"symbolic_name":"course_instructor","field_name":"course_instructor","format":"string","format_code":"string","name":"Course instructor name","short_name":"Instructor","is_question":false,"position_id":null,"question_type_id":null}},["{{cmp}}","by_id_strict"]],"next_report_id":null,"prev_report_id":"1801439851286127363","total_reports":"1417","current_report_num":"1"},"messages":[{"success":true}]},"httpCode":200}},"26":{"request":{"url":"/report/generate","get":{"id":"1801439851286127774","from":null,"to":null,"org_id":"1801439851237913898","csrf":"525689d2e64f8baaaa83e8f94fcf61d4"},"post":{},"requestMethod":"GET"},"response":{"data":{"messages":[{"success":false},{"error":"PGSQL_EMPTY_QUERY\nERROR:  syntax error at or near \"ct_cln_instructors\"\nLINE 4:                 inner ct_cln_instructors pci on pci.id = pci...\n                              ^\nselect (\n                select string_agg(pcin.value, ', ')\n                from ct_cln_event_instructors pcir\n                inner ct_cln_instructors pci on pci.id = pcir.ct_cln_instructor_id\n                inner join ct_cln_instructor_names_ml pcin on pcin.ct_cln_instructor_name_id = pci.name_tid and pcin.ct_language_id = 1\n                where pcir.ct_cln_event_id = pc.id\n            ) as course_instructor\n\n            \n            from ct_cln_candidates c\n            inner join ct_candidate_positions cp on (cp.id = c.ct_last_candidate_position_id)\n\n            inner join ct_cln_positions p on p.id = cp.ct_cln_position_id\n            left join ct_cln_position_names_ml pn on pn.ct_cln_position_name_id = p.name_tid and pn.ct_language_id = 1\n            left join ct_cln_position_single p1 on p1.ct_cln_position_id = p.id\n\n            inner join ct_cln_divisions pd on pd.id = p.ct_cln_division_id\n            left join ct_cln_division_names_ml pdn on pdn.ct_cln_division_name_id = pd.name_tid and pdn.ct_language_id = 1\n\n            left join ct_cln_cluster_positions pclp on pclp.ct_cln_position_id = p.id\n            left join ct_cln_clusters pcl on pcl.id = pclp.ct_cln_cluster_id\n            left join ct_cln_cluster_names_ml pcln on pcln.ct_cln_cluster_name_id = pcl.name_tid and pcln.ct_language_id = 1\n\n            inner join ct_cln_position_statuses ps on ps.id = p.ct_cln_position_status_id\n            inner join ct_cln_position_status_names_ml psn on psn.ct_cln_position_status_name_id = ps.name_tid and psn.ct_language_id = 1\n\n            left join ct_cln_position_status_reasons pr on pr.id = p.ct_cln_position_status_reason_id\n            left join ct_cln_position_status_reason_names_ml prn on prn.ct_cln_position_status_reason_name_id = pr.name_tid and prn.ct_language_id = 1\n\n            inner join ct_cvs cv on cv.id = c.ct_cv_id\n\n            left join ct_addresses a on a.id = cv.ct_address_id\n            left join ct_countries aco on aco.id = a.ct_country_id\n            left join ct_country_names_ml acon on acon.ct_country_name_id = aco.name_tid and acon.ct_language_id = 1\n            left join ct__cities aci on aci.id = a.ct_city_id\n            left join ct_city_names_ml acin on acin.ct_city_name_id = aci.name_tid and acin.ct_language_id = 1\n\n            inner join ct_persons cvp on cvp.id = cv.ct_person_id\n            left join ct_persons_names_of_applicants pna on pna.ct_person_id = cvp.id\n            left join ct_names_of_applicants_ml na on na.ct_person_name_id = pna.name_tid and na.ct_language_id = 1\n            left join ct_persons_surnames_of_applicants psa on psa.ct_person_id = cvp.id\n            left join ct_surnames_of_applicants_ml sa on sa.ct_person_surname_id = psa.surname_tid and sa.ct_language_id = 1\n\n            inner join ct_cv_sources cvs on cvs.id = cp.ct_cv_source_id\n            inner join ct_cv_source_names_ml cvsn on cvsn.ct_cv_source_name_id = cvs.name_tid and cvsn.ct_language_id = 1\n\n            inner join ct_candidate_statuses acs on acs.id = cp.ct_global_status_id\n            inner join ct_candidate_statuse_names_ml acsn on acsn.ct_candidate_statuse_name_id = acs.name_tid and acsn.ct_language_id = 1\n\n            left join ct_position_steps pst on pst.id = cp.ct_current_step_id\n            left join ct_cln_steps cst on cst.id = pst.ct_cln_step_id\n            left join ct_cln_step_names_ml cstn on cstn.ct_cln_step_name_id = cst.name_tid and cstn.ct_language_id = 1\n\n            left join ct_cln_position_step_tags pstt on pstt.id = pst.ct_cln_position_step_tag_id\n            left join ct_cln_position_step_tag_names_ml psttn on psttn.ct_cln_position_step_tag_name_id = pstt.name_tid and psttn.ct_language_id = 1\n\n            left join ct_candidate_steps st on st.ct_candidate_position_id = cp.id and st.ct_position_step_id = pst.id\n            left join ct_candidate_step_notices_ml note on note.ct_candidate_step_notice_id = st.notice_tid and note.ct_language_id = 1\n\n            left join ct_cln_reasons r on r.id = st.ct_cln_reason_id\n            left join ct_cln_reason_names_ml rn on rn.ct_cln_reason_name_id = r.name_tid and rn.ct_language_id = 1\n\n            left join ct_cln_events pc on pc.id = cp.ct_cln_event_id\n            left join ct_cln_event_names_ml pcn on pcn.cln_event_names_id = pc.name_tid and pcn.ct_language_id = 1\n        \n\n            where true\nand cp.ct_cln_position_id in ('1801439851285955895')","traces":[{"file":"/var/www/callnet-api.synergetica.net/application/classes/Db.php","line":19,"function":"exec","class":"ErrorThrowDatabase","type":"->","args":["select (\n                select string_agg(pcin.value, ', ')\n                from ct_cln_event_instructors pcir\n                inner ct_cln_instructors pci on pci.id = pcir.ct_cln_instructor_id\n                inner join ct_cln_instructor_names_ml pcin on pcin.ct_cln_instructor_name_id = pci.name_tid and pcin.ct_language_id = 1\n                where pcir.ct_cln_event_id = pc.id\n            ) as course_instructor\n\n            \n            from ct_cln_candidates c\n            inner join ct_candidate_positions cp on (cp.id = c.ct_last_candidate_position_id)\n\n            inner join ct_cln_positions p on p.id = cp.ct_cln_position_id\n            left join ct_cln_position_names_ml pn on pn.ct_cln_position_name_id = p.name_tid and pn.ct_language_id = 1\n            left join ct_cln_position_single p1 on p1.ct_cln_position_id = p.id\n\n            inner join ct_cln_divisions pd on pd.id = p.ct_cln_division_id\n            left join ct_cln_division_names_ml pdn on pdn.ct_cln_division_name_id = pd.name_tid and pdn.ct_language_id = 1\n\n            left join ct_cln_cluster_positions pclp on pclp.ct_cln_position_id = p.id\n            left join ct_cln_clusters pcl on pcl.id = pclp.ct_cln_cluster_id\n            left join ct_cln_cluster_names_ml pcln on pcln.ct_cln_cluster_name_id = pcl.name_tid and pcln.ct_language_id = 1\n\n            inner join ct_cln_position_statuses ps on ps.id = p.ct_cln_position_status_id\n            inner join ct_cln_position_status_names_ml psn on psn.ct_cln_position_status_name_id = ps.name_tid and psn.ct_language_id = 1\n\n            left join ct_cln_position_status_reasons pr on pr.id = p.ct_cln_position_status_reason_id\n            left join ct_cln_position_status_reason_names_ml prn on prn.ct_cln_position_status_reason_name_id = pr.name_tid and prn.ct_language_id = 1\n\n            inner join ct_cvs cv on cv.id = c.ct_cv_id\n\n            left join ct_addresses a on a.id = cv.ct_address_id\n            left join ct_countries aco on aco.id = a.ct_country_id\n            left join ct_country_names_ml acon on acon.ct_country_name_id = aco.name_tid and acon.ct_language_id = 1\n            left join ct__cities aci on aci.id = a.ct_city_id\n            left join ct_city_names_ml acin on acin.ct_city_name_id = aci.name_tid and acin.ct_language_id = 1\n\n            inner join ct_persons cvp on cvp.id = cv.ct_person_id\n            left join ct_persons_names_of_applicants pna on pna.ct_person_id = cvp.id\n            left join ct_names_of_applicants_ml na on na.ct_person_name_id = pna.name_tid and na.ct_language_id = 1\n            left join ct_persons_surnames_of_applicants psa on psa.ct_person_id = cvp.id\n            left join ct_surnames_of_applicants_ml sa on sa.ct_person_surname_id = psa.surname_tid and sa.ct_language_id = 1\n\n            inner join ct_cv_sources cvs on cvs.id = cp.ct_cv_source_id\n            inner join ct_cv_source_names_ml cvsn on cvsn.ct_cv_source_name_id = cvs.name_tid and cvsn.ct_language_id = 1\n\n            inner join ct_candidate_statuses acs on acs.id = cp.ct_global_status_id\n            inner join ct_candidate_statuse_names_ml acsn on acsn.ct_candidate_statuse_name_id = acs.name_tid and acsn.ct_language_id = 1\n\n            left join ct_position_steps pst on pst.id = cp.ct_current_step_id\n            left join ct_cln_steps cst on cst.id = pst.ct_cln_step_id\n            left join ct_cln_step_names_ml cstn on cstn.ct_cln_step_name_id = cst.name_tid and cstn.ct_language_id = 1\n\n            left join ct_cln_position_step_tags pstt on pstt.id = pst.ct_cln_position_step_tag_id\n            left join ct_cln_position_step_tag_names_ml psttn on psttn.ct_cln_position_step_tag_name_id = pstt.name_tid and psttn.ct_language_id = 1\n\n            left join ct_candidate_steps st on st.ct_candidate_position_id = cp.id and st.ct_position_step_id = pst.id\n            left join ct_candidate_step_notices_ml note on note.ct_candidate_step_notice_id = st.notice_tid and note.ct_language_id = 1\n\n            left join ct_cln_reasons r on r.id = st.ct_cln_reason_id\n            left join ct_cln_reason_names_ml rn on rn.ct_cln_reason_name_id = r.name_tid and rn.ct_language_id = 1\n\n            left join ct_cln_events pc on pc.id = cp.ct_cln_event_id\n            left join ct_cln_event_names_ml pcn on pcn.cln_event_names_id = pc.name_tid and pcn.ct_language_id = 1\n        \n\n            where true\nand cp.ct_cln_position_id in ('1801439851285955895')"]},{"file":"/var/www/erp_synergy/core/db.php","line":105,"function":"exec","class":"Callnet\\Db","type":"->","args":["select (\n                select string_agg(pcin.value, ', ')\n                from ct_cln_event_instructors pcir\n                inner ct_cln_instructors pci on pci.id = pcir.ct_cln_instructor_id\n                inner join ct_cln_instructor_names_ml pcin on pcin.ct_cln_instructor_name_id = pci.name_tid and pcin.ct_language_id = 1\n                where pcir.ct_cln_event_id = pc.id\n            ) as course_instructor\n\n            \n            from ct_cln_candidates c\n            inner join ct_candidate_positions cp on (cp.id = c.ct_last_candidate_position_id)\n\n            inner join ct_cln_positions p on p.id = cp.ct_cln_position_id\n            left join ct_cln_position_names_ml pn on pn.ct_cln_position_name_id = p.name_tid and pn.ct_language_id = 1\n            left join ct_cln_position_single p1 on p1.ct_cln_position_id = p.id\n\n            inner join ct_cln_divisions pd on pd.id = p.ct_cln_division_id\n            left join ct_cln_division_names_ml pdn on pdn.ct_cln_division_name_id = pd.name_tid and pdn.ct_language_id = 1\n\n            left join ct_cln_cluster_positions pclp on pclp.ct_cln_position_id = p.id\n            left join ct_cln_clusters pcl on pcl.id = pclp.ct_cln_cluster_id\n            left join ct_cln_cluster_names_ml pcln on pcln.ct_cln_cluster_name_id = pcl.name_tid and pcln.ct_language_id = 1\n\n            inner join ct_cln_position_statuses ps on ps.id = p.ct_cln_position_status_id\n            inner join ct_cln_position_status_names_ml psn on psn.ct_cln_position_status_name_id = ps.name_tid and psn.ct_language_id = 1\n\n            left join ct_cln_position_status_reasons pr on pr.id = p.ct_cln_position_status_reason_id\n            left join ct_cln_position_status_reason_names_ml prn on prn.ct_cln_position_status_reason_name_id = pr.name_tid and prn.ct_language_id = 1\n\n            inner join ct_cvs cv on cv.id = c.ct_cv_id\n\n            left join ct_addresses a on a.id = cv.ct_address_id\n            left join ct_countries aco on aco.id = a.ct_country_id\n            left join ct_country_names_ml acon on acon.ct_country_name_id = aco.name_tid and acon.ct_language_id = 1\n            left join ct__cities aci on aci.id = a.ct_city_id\n            left join ct_city_names_ml acin on acin.ct_city_name_id = aci.name_tid and acin.ct_language_id = 1\n\n            inner join ct_persons cvp on cvp.id = cv.ct_person_id\n            left join ct_persons_names_of_applicants pna on pna.ct_person_id = cvp.id\n            left join ct_names_of_applicants_ml na on na.ct_person_name_id = pna.name_tid and na.ct_language_id = 1\n            left join ct_persons_surnames_of_applicants psa on psa.ct_person_id = cvp.id\n            left join ct_surnames_of_applicants_ml sa on sa.ct_person_surname_id = psa.surname_tid and sa.ct_language_id = 1\n\n            inner join ct_cv_sources cvs on cvs.id = cp.ct_cv_source_id\n            inner join ct_cv_source_names_ml cvsn on cvsn.ct_cv_source_name_id = cvs.name_tid and cvsn.ct_language_id = 1\n\n            inner join ct_candidate_statuses acs on acs.id = cp.ct_global_status_id\n            inner join ct_candidate_statuse_names_ml acsn on acsn.ct_candidate_statuse_name_id = acs.name_tid and acsn.ct_language_id = 1\n\n            left join ct_position_steps pst on pst.id = cp.ct_current_step_id\n            left join ct_cln_steps cst on cst.id = pst.ct_cln_step_id\n            left join ct_cln_step_names_ml cstn on cstn.ct_cln_step_name_id = cst.name_tid and cstn.ct_language_id = 1\n\n            left join ct_cln_position_step_tags pstt on pstt.id = pst.ct_cln_position_step_tag_id\n            left join ct_cln_position_step_tag_names_ml psttn on psttn.ct_cln_position_step_tag_name_id = pstt.name_tid and psttn.ct_language_id = 1\n\n            left join ct_candidate_steps st on st.ct_candidate_position_id = cp.id and st.ct_position_step_id = pst.id\n            left join ct_candidate_step_notices_ml note on note.ct_candidate_step_notice_id = st.notice_tid and note.ct_language_id = 1\n\n            left join ct_cln_reasons r on r.id = st.ct_cln_reason_id\n            left join ct_cln_reason_names_ml rn on rn.ct_cln_reason_name_id = r.name_tid and rn.ct_language_id = 1\n\n            left join ct_cln_events pc on pc.id = cp.ct_cln_event_id\n            left join ct_cln_event_names_ml pcn on pcn.cln_event_names_id = pc.name_tid and pcn.ct_language_id = 1\n        \n\n            where true\nand cp.ct_cln_position_id in ('1801439851285955895')"]},{"file":"/var/www/callnet-api.synergetica.net/application/classes/Db.php","line":186,"function":"execute","class":"Database","type":"->","args":["\n            \n\n            select (\n                select string_agg(pcin.value, ', ')\n                from ct_cln_event_instructors pcir\n                inner ct_cln_instructors pci on pci.id = pcir.ct_cln_instructor_id\n                inner join ct_cln_instructor_names_ml pcin on pcin.ct_cln_instructor_name_id = pci.name_tid and pcin.ct_language_id = 1\n                where pcir.ct_cln_event_id = pc.id\n            ) as course_instructor\n\n            \n            from ct_cln_candidates c\n            inner join ct_candidate_positions cp on (cp.id = c.ct_last_candidate_position_id)\n\n            inner join ct_cln_positions p on p.id = cp.ct_cln_position_id\n            left join ct_cln_position_names_ml pn on pn.ct_cln_position_name_id = p.name_tid and pn.ct_language_id = 1\n            left join ct_cln_position_single p1 on p1.ct_cln_position_id = p.id\n\n            inner join ct_cln_divisions pd on pd.id = p.ct_cln_division_id\n            left join ct_cln_division_names_ml pdn on pdn.ct_cln_division_name_id = pd.name_tid and pdn.ct_language_id = 1\n\n            left join ct_cln_cluster_positions pclp on pclp.ct_cln_position_id = p.id\n            left join ct_cln_clusters pcl on pcl.id = pclp.ct_cln_cluster_id\n            left join ct_cln_cluster_names_ml pcln on pcln.ct_cln_cluster_name_id = pcl.name_tid and pcln.ct_language_id = 1\n\n            inner join ct_cln_position_statuses ps on ps.id = p.ct_cln_position_status_id\n            inner join ct_cln_position_status_names_ml psn on psn.ct_cln_position_status_name_id = ps.name_tid and psn.ct_language_id = 1\n\n            left join ct_cln_position_status_reasons pr on pr.id = p.ct_cln_position_status_reason_id\n            left join ct_cln_position_status_reason_names_ml prn on prn.ct_cln_position_status_reason_name_id = pr.name_tid and prn.ct_language_id = 1\n\n            inner join ct_cvs cv on cv.id = c.ct_cv_id\n\n            left join ct_addresses a on a.id = cv.ct_address_id\n            left join ct_countries aco on aco.id = a.ct_country_id\n            left join ct_country_names_ml acon on acon.ct_country_name_id = aco.name_tid and acon.ct_language_id = 1\n            left join ct__cities aci on aci.id = a.ct_city_id\n            left join ct_city_names_ml acin on acin.ct_city_name_id = aci.name_tid and acin.ct_language_id = 1\n\n            inner join ct_persons cvp on cvp.id = cv.ct_person_id\n            left join ct_persons_names_of_applicants pna on pna.ct_person_id = cvp.id\n            left join ct_names_of_applicants_ml na on na.ct_person_name_id = pna.name_tid and na.ct_language_id = 1\n            left join ct_persons_surnames_of_applicants psa on psa.ct_person_id = cvp.id\n            left join ct_surnames_of_applicants_ml sa on sa.ct_person_surname_id = psa.surname_tid and sa.ct_language_id = 1\n\n            inner join ct_cv_sources cvs on cvs.id = cp.ct_cv_source_id\n            inner join ct_cv_source_names_ml cvsn on cvsn.ct_cv_source_name_id = cvs.name_tid and cvsn.ct_language_id = 1\n\n            inner join ct_candidate_statuses acs on acs.id = cp.ct_global_status_id\n            inner join ct_candidate_statuse_names_ml acsn on acsn.ct_candidate_statuse_name_id = acs.name_tid and acsn.ct_language_id = 1\n\n            left join ct_position_steps pst on pst.id = cp.ct_current_step_id\n            left join ct_cln_steps cst on cst.id = pst.ct_cln_step_id\n            left join ct_cln_step_names_ml cstn on cstn.ct_cln_step_name_id = cst.name_tid and cstn.ct_language_id = 1\n\n            left join ct_cln_position_step_tags pstt on pstt.id = pst.ct_cln_position_step_tag_id\n            left join ct_cln_position_step_tag_names_ml psttn on psttn.ct_cln_position_step_tag_name_id = pstt.name_tid and psttn.ct_language_id = 1\n\n            left join ct_candidate_steps st on st.ct_candidate_position_id = cp.id and st.ct_position_step_id = pst.id\n            left join ct_candidate_step_notices_ml note on note.ct_candidate_step_notice_id = st.notice_tid and note.ct_language_id = 1\n\n            left join ct_cln_reasons r on r.id = st.ct_cln_reason_id\n            left join ct_cln_reason_names_ml rn on rn.ct_cln_reason_name_id = r.name_tid and rn.ct_language_id = 1\n\n            left join ct_cln_events pc on pc.id = cp.ct_cln_event_id\n            left join ct_cln_event_names_ml pcn on pcn.cln_event_names_id = pc.name_tid and pcn.ct_language_id = 1\n        \n\n            where true\nand cp.ct_cln_position_id in ('1801439851285955895')\n\n            \n\n            \n        "]},{"file":"/var/www/callnet-api.synergetica.net/application/classes/Concept/Report.php","line":818,"function":"getAllRows","class":"Callnet\\Db","type":"::","args":["\n            \n\n            select (\n                select string_agg(pcin.value, ', ')\n                from ct_cln_event_instructors pcir\n                inner ct_cln_instructors pci on pci.id = pcir.ct_cln_instructor_id\n                inner join ct_cln_instructor_names_ml pcin on pcin.ct_cln_instructor_name_id = pci.name_tid and pcin.ct_language_id = 1\n                where pcir.ct_cln_event_id = pc.id\n            ) as course_instructor\n\n            \n            from ct_cln_candidates c\n            inner join ct_candidate_positions cp on (cp.id = c.ct_last_candidate_position_id)\n\n            inner join ct_cln_positions p on p.id = cp.ct_cln_position_id\n            left join ct_cln_position_names_ml pn on pn.ct_cln_position_name_id = p.name_tid and pn.ct_language_id = 1\n            left join ct_cln_position_single p1 on p1.ct_cln_position_id = p.id\n\n            inner join ct_cln_divisions pd on pd.id = p.ct_cln_division_id\n            left join ct_cln_division_names_ml pdn on pdn.ct_cln_division_name_id = pd.name_tid and pdn.ct_language_id = 1\n\n            left join ct_cln_cluster_positions pclp on pclp.ct_cln_position_id = p.id\n            left join ct_cln_clusters pcl on pcl.id = pclp.ct_cln_cluster_id\n            left join ct_cln_cluster_names_ml pcln on pcln.ct_cln_cluster_name_id = pcl.name_tid and pcln.ct_language_id = 1\n\n            inner join ct_cln_position_statuses ps on ps.id = p.ct_cln_position_status_id\n            inner join ct_cln_position_status_names_ml psn on psn.ct_cln_position_status_name_id = ps.name_tid and psn.ct_language_id = 1\n\n            left join ct_cln_position_status_reasons pr on pr.id = p.ct_cln_position_status_reason_id\n            left join ct_cln_position_status_reason_names_ml prn on prn.ct_cln_position_status_reason_name_id = pr.name_tid and prn.ct_language_id = 1\n\n            inner join ct_cvs cv on cv.id = c.ct_cv_id\n\n            left join ct_addresses a on a.id = cv.ct_address_id\n            left join ct_countries aco on aco.id = a.ct_country_id\n            left join ct_country_names_ml acon on acon.ct_country_name_id = aco.name_tid and acon.ct_language_id = 1\n            left join ct__cities aci on aci.id = a.ct_city_id\n            left join ct_city_names_ml acin on acin.ct_city_name_id = aci.name_tid and acin.ct_language_id = 1\n\n            inner join ct_persons cvp on cvp.id = cv.ct_person_id\n            left join ct_persons_names_of_applicants pna on pna.ct_person_id = cvp.id\n            left join ct_names_of_applicants_ml na on na.ct_person_name_id = pna.name_tid and na.ct_language_id = 1\n            left join ct_persons_surnames_of_applicants psa on psa.ct_person_id = cvp.id\n            left join ct_surnames_of_applicants_ml sa on sa.ct_person_surname_id = psa.surname_tid and sa.ct_language_id = 1\n\n            inner join ct_cv_sources cvs on cvs.id = cp.ct_cv_source_id\n            inner join ct_cv_source_names_ml cvsn on cvsn.ct_cv_source_name_id = cvs.name_tid and cvsn.ct_language_id = 1\n\n            inner join ct_candidate_statuses acs on acs.id = cp.ct_global_status_id\n            inner join ct_candidate_statuse_names_ml acsn on acsn.ct_candidate_statuse_name_id = acs.name_tid and acsn.ct_language_id = 1\n\n            left join ct_position_steps pst on pst.id = cp.ct_current_step_id\n            left join ct_cln_steps cst on cst.id = pst.ct_cln_step_id\n            left join ct_cln_step_names_ml cstn on cstn.ct_cln_step_name_id = cst.name_tid and cstn.ct_language_id = 1\n\n            left join ct_cln_position_step_tags pstt on pstt.id = pst.ct_cln_position_step_tag_id\n            left join ct_cln_position_step_tag_names_ml psttn on psttn.ct_cln_position_step_tag_name_id = pstt.name_tid and psttn.ct_language_id = 1\n\n            left join ct_candidate_steps st on st.ct_candidate_position_id = cp.id and st.ct_position_step_id = pst.id\n            left join ct_candidate_step_notices_ml note on note.ct_candidate_step_notice_id = st.notice_tid and note.ct_language_id = 1\n\n            left join ct_cln_reasons r on r.id = st.ct_cln_reason_id\n            left join ct_cln_reason_names_ml rn on rn.ct_cln_reason_name_id = r.name_tid and rn.ct_language_id = 1\n\n            left join ct_cln_events pc on pc.id = cp.ct_cln_event_id\n            left join ct_cln_event_names_ml pcn on pcn.cln_event_names_id = pc.name_tid and pcn.ct_language_id = 1\n        \n\n            where true\nand cp.ct_cln_position_id in ('1801439851285955895')\n\n            \n\n            \n        "]},{"file":"/var/www/callnet-api.synergetica.net/application/classes/Concept/Report.php","line":1097,"function":"generateRaw","class":"Callnet\\Concept\\Report","type":"->","args":[{"id":"1801439851286127774","type_id":"1801439851250353089","report_types":{"id":"1801439851250353089","symbolic_name":"raw","name":"Raw Data"},"funnel_type_id":"1801439851269656904","funnel_report_types":{"id":"1801439851269656904","symbolic_name":"single_position","name":"Single position"},"excel_type_id":"1801439851269649543","excel_report_types":{"id":"1801439851269649543","symbolic_name":"cv_sources_by_position","field1":"CV source","field2":"Position","name":"CV sources by position"},"position_step_tag_id":null,"position_step_tags":null,"template_id":"1801439851250356367","report_templates":{"id":"1801439851250356367","symbolic_name":"custom","report_type_id":"1801439851250353089","report_types":{"id":"1801439851250353089","symbolic_name":"raw","name":"Raw Data"},"name":"Custom report","preselected_metrics":[]},"date_interval_type_id":"1801439851279108495","date_interval_types":{"id":"1801439851279108495","symbolic_name":"all","name":"All"},"start_date":null,"end_date":null,"is_rejection_date":false,"compare":false,"compare_custom":false,"compare_start_date":null,"compare_end_date":null,"name":"VVVV","report_positions":[{"id":"1801439851286127781","report_id":"1801439851286127774","position_id":"1801439851285955895"}],"report_statuses":[],"report_countries":[],"report_clusters":[],"report_cv_sources":[],"report_courses":[],"metrics":[{"id":"1801439851286127782","report_id":"1801439851286127774","metric_type_id":"1801439851280102093","metric_types":{"id":"1801439851280102093","editable":false,"sortable":true,"can_view_chart":true,"symbolic_name":"course_instructor","field_name":"course_instructor","format":"string","format_code":"string","name":"Course instructor name","short_name":"Instructor","is_question":false,"position_id":null,"question_type_id":null}}]},null,null]},{"file":"/var/www/callnet-api.synergetica.net/application/controllers/ReportController.php","line":81,"function":"generate","class":"Callnet\\Concept\\Report","type":"->","args":[null,null]},{"function":"generateAction","class":"Callnet\\ReportController","type":"->","args":[]},{"file":"/var/www/erp_synergy/core/BaseController.php","line":87,"function":"call_user_func","args":[[{},"generateAction"]]},{"file":"/var/www/erp_synergy/core/Application.php","line":167,"function":"invokeAction","class":"ERP_Core_BaseController","type":"->","args":["generate"]},{"file":"/var/www/erp_synergy/core/Application.php","line":59,"function":"processURI","class":"ERP_Core_Application","type":"->","args":[]},{"file":"/var/www/callnet-api.synergetica.net/api.php","line":7,"function":"run","class":"ERP_Core_Application","type":"->","args":[]}]}]},"httpCode":500}}}