{"iTotalDisplayRecords":"35","query":"\r\nSELECT SQL_CALC_FOUND_ROWS `customer_query_id`, `customer_query_number`, `customer_query_booking`, `customer_query_title`, `customer_query_detail`, `customer_query_status`, `customer_query_added_by`, `customer_query_added_on`, `customer_query_assigned_to`, `customer_query_assigned_on`, `crm_site_no`, `status_name`, `project_name`, `project_id`, `enquiry_number`, `booked_customer_name`, `crm_customer_contact_no_one`, `crm_customer_contact_no_two`, `crm_customer_contact_no_three`, `crm_customer_contact_no_four`, `crm_customer_email_id_one`, `customer_query_status_name`, `customer_query_assigned_to_user_name`\r\nFROM customer_query_view\r\n Where `customer_query_status` NOT IN ( 4, 5)\r\nORDER BY customer_query_added_on DESC\r\n\r\n","aaData":[{"customer_query_id":"62","customer_query_number":"KNS62","customer_query_booking":"863","customer_query_title":"sadanand","customer_query_detail":"sadanand","customer_query_status":"1","customer_query_added_by":"2490","customer_query_added_on":"2026-02-19 11:01:42","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"124","status_name":"Katha Transfer","project_name":"UNNATI PHASE - 1","project_id":"3","enquiry_number":"KNS-AUG-JAG-17279","booked_customer_name":"Jagannath","crm_customer_contact_no_one":"9900028821","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":191,"documentCount":0},{"customer_query_id":"61","customer_query_number":"KNS61","customer_query_booking":"277","customer_query_title":"Boundary","customer_query_detail":"1 to 10","customer_query_status":"2","customer_query_added_by":"144103293276609500","customer_query_added_on":"2025-10-15 19:12:14","customer_query_assigned_to":"170806010621391400","customer_query_assigned_on":"2025-10-15 19:12:44","crm_site_no":"6","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-SEP-PRI-4522","booked_customer_name":"Mr. MOHAN BABU SREERAMULU","crm_customer_contact_no_one":"9900544388","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"nkumar0507@yahoo.co.in","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"MONISHA","customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":318,"documentCount":0},{"customer_query_id":"60","customer_query_number":"KNS60","customer_query_booking":"3569","customer_query_title":"ok","customer_query_detail":"k","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2025-07-21 23:09:59","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":404,"documentCount":0},{"customer_query_id":"59","customer_query_number":"KNS59","customer_query_booking":"3569","customer_query_title":"ok","customer_query_detail":"k","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2025-07-21 22:45:05","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":404,"documentCount":0},{"customer_query_id":"58","customer_query_number":"KNS58","customer_query_booking":"3569","customer_query_title":"ok","customer_query_detail":"ok","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2025-07-21 21:55:01","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":404,"documentCount":0},{"customer_query_id":"57","customer_query_number":"KNS57","customer_query_booking":"3569","customer_query_title":"ok","customer_query_detail":"ok","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2025-07-21 13:23:59","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":404,"documentCount":0},{"customer_query_id":"56","customer_query_number":"KNS56","customer_query_booking":"3569","customer_query_title":"testing","customer_query_detail":"testing","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2025-07-21 11:00:54","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":404,"documentCount":0},{"customer_query_id":"55","customer_query_number":"KNS55","customer_query_booking":"4670","customer_query_title":"Wrong transaction receipt","customer_query_detail":"Transaction receipts reflects the name of other person and incorrect payment number made on 20-06-2023","customer_query_status":"1","customer_query_added_by":"4558","customer_query_added_on":"2023-06-20 14:58:49","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"54","status_name":"Katha Transfer","project_name":"KNS ATHARVA","project_id":"38","enquiry_number":"KNS-R-JAN-USH-238902","booked_customer_name":"Mr.Sunil S","crm_customer_contact_no_one":"919663670876","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"sunilsyadav1994@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1166,"documentCount":0},{"customer_query_id":"54","customer_query_number":"KNS54","customer_query_booking":"3546","customer_query_title":"devendrappa","customer_query_detail":"hai thish is devenadarappa","customer_query_status":"1","customer_query_added_by":"3345","customer_query_added_on":"2022-11-28 11:32:02","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. RUPESH SINGH","crm_customer_contact_no_one":"919964643737","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1370,"documentCount":0},{"customer_query_id":"53","customer_query_number":"KNS53","customer_query_booking":"3546","customer_query_title":"nithish","customer_query_detail":"hai this is nithish","customer_query_status":"1","customer_query_added_by":"3345","customer_query_added_on":"2022-11-28 11:30:15","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. RUPESH SINGH","crm_customer_contact_no_one":"919964643737","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1370,"documentCount":0},{"customer_query_id":"52","customer_query_number":"KNS52","customer_query_booking":"863","customer_query_title":"Water line ","customer_query_detail":"My site water line is not working ","customer_query_status":"2","customer_query_added_by":"2490","customer_query_added_on":"2022-08-13 13:20:43","customer_query_assigned_to":"159168188652045100","customer_query_assigned_on":"2022-08-13 13:23:38","crm_site_no":"124","status_name":"Katha Transfer","project_name":"UNNATI PHASE - 1","project_id":"3","enquiry_number":"KNS-AUG-JAG-17279","booked_customer_name":"Jagannath","crm_customer_contact_no_one":"9900028821","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"RADHIKA N","customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1477,"documentCount":0},{"customer_query_id":"51","customer_query_number":"KNS51","customer_query_booking":"3546","customer_query_title":"Kns 001","customer_query_detail":"Kns0001","customer_query_status":"1","customer_query_added_by":"3345","customer_query_added_on":"2022-05-21 11:55:36","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. RUPESH SINGH","crm_customer_contact_no_one":"919964643737","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"Hello","customer_query_follow_up_on":"2022-05-21 11:55:59","total_lead_time":1561,"documentCount":0},{"customer_query_id":"50","customer_query_number":"KNS50","customer_query_booking":"3925","customer_query_title":"test test test","customer_query_detail":"tresr tresert trress","customer_query_status":"1","customer_query_added_by":"2757","customer_query_added_on":"2022-05-19 14:37:24","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"76","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-FEB-PUN-96658","booked_customer_name":"Smt Uma T","crm_customer_contact_no_one":"9448220636","crm_customer_contact_no_two":"9449738535","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"gm.mceip@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"Comment ","customer_query_follow_up_on":"2022-05-21 10:26:23","total_lead_time":1563,"documentCount":0},{"customer_query_id":"49","customer_query_number":"KNS49","customer_query_booking":"3925","customer_query_title":"wrong not working","customer_query_detail":"shows only one site","customer_query_status":"2","customer_query_added_by":"3241","customer_query_added_on":"2022-05-19 11:12:58","customer_query_assigned_to":"158270827163566700","customer_query_assigned_on":"2022-05-19 11:13:34","crm_site_no":"76","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-FEB-PUN-96658","booked_customer_name":"Smt Uma T","crm_customer_contact_no_one":"9448220636","crm_customer_contact_no_two":"9449738535","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"gm.mceip@gmail.com","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"SHANKAR P TOLI","customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1563,"documentCount":0},{"customer_query_id":"47","customer_query_number":"KNS47","customer_query_booking":"3925","customer_query_title":"Test","customer_query_detail":"Test\n","customer_query_status":"3","customer_query_added_by":"3712","customer_query_added_on":"2022-05-18 14:57:07","customer_query_assigned_to":"159168188652045100","customer_query_assigned_on":"2022-05-18 14:58:43","crm_site_no":"76","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-FEB-PUN-96658","booked_customer_name":"Smt Uma T","crm_customer_contact_no_one":"9448220636","crm_customer_contact_no_two":"9449738535","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"gm.mceip@gmail.com","customer_query_status_name":"In Progress","customer_query_assigned_to_user_name":"RADHIKA N","customer_query_follow_up_remark":"test","customer_query_follow_up_on":"2022-05-18 15:16:05","total_lead_time":1564,"documentCount":0},{"customer_query_id":"46","customer_query_number":"KNS46","customer_query_booking":"3925","customer_query_title":"Test electric issue","customer_query_detail":"Fuse not going","customer_query_status":"2","customer_query_added_by":"3712","customer_query_added_on":"2022-05-18 14:56:41","customer_query_assigned_to":"159168188652045100","customer_query_assigned_on":"2022-05-18 14:59:34","crm_site_no":"76","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-FEB-PUN-96658","booked_customer_name":"Smt Uma T","crm_customer_contact_no_one":"9448220636","crm_customer_contact_no_two":"9449738535","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"gm.mceip@gmail.com","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"RADHIKA N","customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1564,"documentCount":0},{"customer_query_id":"45","customer_query_number":"KNS45","customer_query_booking":"3925","customer_query_title":"Test electric issue","customer_query_detail":"Fuse not going","customer_query_status":"1","customer_query_added_by":"3712","customer_query_added_on":"2022-05-18 14:56:25","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"76","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-FEB-PUN-96658","booked_customer_name":"Smt Uma T","crm_customer_contact_no_one":"9448220636","crm_customer_contact_no_two":"9449738535","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"gm.mceip@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1564,"documentCount":0},{"customer_query_id":"44","customer_query_number":"KNS44","customer_query_booking":"2647","customer_query_title":"testing ","customer_query_detail":"testing","customer_query_status":"1","customer_query_added_by":"1685","customer_query_added_on":"2022-04-14 11:02:59","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"379","status_name":"Katha Transfer","project_name":"KNS ETHOS","project_id":"21","enquiry_number":"KNS-JAN-JAN-66425","booked_customer_name":"Sri R Srinivasappa","crm_customer_contact_no_one":"8073114544","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"jagadishs2019@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1598,"documentCount":0},{"customer_query_id":"43","customer_query_number":"KNS43","customer_query_booking":"3888","customer_query_title":"Legal Quires","customer_query_detail":"Required EC ","customer_query_status":"1","customer_query_added_by":"3712","customer_query_added_on":"2022-04-14 10:53:24","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"281","status_name":"Katha Transfer","project_name":"KNS NESTER","project_id":"23","enquiry_number":"KNS-MAR-KNS-174313","booked_customer_name":"Mr. Y C Huchamasti Gowda","crm_customer_contact_no_one":"9174545130523","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"radhika@knsgroup.in","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"Can u plz rpy to my query","customer_query_follow_up_on":"2022-04-14 11:03:03","total_lead_time":1598,"documentCount":0},{"customer_query_id":"42","customer_query_number":"KNS42","customer_query_booking":"3730","customer_query_title":"test","customer_query_detail":"test 1","customer_query_status":"1","customer_query_added_by":"3543","customer_query_added_on":"2022-04-14 10:43:03","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"108","status_name":"Katha Transfer","project_name":"MANTRI KNS CARICA\n","project_id":"22","enquiry_number":"KNS-JAN-KNS-163262","booked_customer_name":"Mr. Vikas H K ","crm_customer_contact_no_one":"9980527222","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"arpithatn@knsgroup.in","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1598,"documentCount":0},{"customer_query_id":"41","customer_query_number":"KNS41","customer_query_booking":"863","customer_query_title":"Site cleaning ","customer_query_detail":"Kindly get my site cleaned ","customer_query_status":"1","customer_query_added_by":"2490","customer_query_added_on":"2022-03-26 16:06:29","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"124","status_name":"Katha Transfer","project_name":"UNNATI PHASE - 1","project_id":"3","enquiry_number":"KNS-AUG-JAG-17279","booked_customer_name":"Jagannath","crm_customer_contact_no_one":"9900028821","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1617,"documentCount":0},{"customer_query_id":"40","customer_query_number":"KNS40","customer_query_booking":"3569","customer_query_title":"5th ticket","customer_query_detail":"5th ticket","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2022-03-04 13:16:20","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"comment 4","customer_query_follow_up_on":"2022-05-21 10:45:22","total_lead_time":1639,"documentCount":0},{"customer_query_id":"39","customer_query_number":"KNS38","customer_query_booking":"3569","customer_query_title":"4th test","customer_query_detail":"4 the test","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2022-03-04 13:14:32","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1639,"documentCount":0},{"customer_query_id":"36","customer_query_number":"KNS36","customer_query_booking":"3569","customer_query_title":"ffff","customer_query_detail":"gggg","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2022-03-04 13:08:31","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1639,"documentCount":0},{"customer_query_id":"35","customer_query_number":"KNS35","customer_query_booking":"3569","customer_query_title":"testing","customer_query_detail":"testuing","customer_query_status":"1","customer_query_added_by":"2147483647","customer_query_added_on":"2022-03-02 19:15:59","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 10:10:10","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":0},{"customer_query_id":"34","customer_query_number":"KNS34","customer_query_booking":"2153","customer_query_title":"vtesting ","customer_query_detail":"vtesting","customer_query_status":"1","customer_query_added_by":"3345","customer_query_added_on":"2022-03-02 16:15:53","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"275","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - A","project_id":"7","enquiry_number":"KNS-APR-RAN-42147","booked_customer_name":"Pabbathi Niranjan","crm_customer_contact_no_one":"9916481410","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"niranjan.pabbathi@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":0},{"customer_query_id":"33","customer_query_number":"KNS33","customer_query_booking":"883","customer_query_title":"power issue","customer_query_detail":"remote issue","customer_query_status":"3","customer_query_added_by":"2757","customer_query_added_on":"2022-03-02 15:58:29","customer_query_assigned_to":"157224352626450200","customer_query_assigned_on":"2022-03-02 15:59:03","crm_site_no":"353","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-AUG-JAG-17104","booked_customer_name":"Shashidhar Shetty","crm_customer_contact_no_one":"8494951190","crm_customer_contact_no_two":"8494951190","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"In Progress","customer_query_assigned_to_user_name":"ARPITHA.TN","customer_query_follow_up_remark":"working with intenal team","customer_query_follow_up_on":"2022-03-02 15:59:28","total_lead_time":1641,"documentCount":0},{"customer_query_id":"32","customer_query_number":"KNS32","customer_query_booking":"2153","customer_query_title":"vtesting","customer_query_detail":"vtesting","customer_query_status":"1","customer_query_added_by":"3368","customer_query_added_on":"2022-03-02 13:09:32","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"275","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - A","project_id":"7","enquiry_number":"KNS-APR-RAN-42147","booked_customer_name":"Pabbathi Niranjan","crm_customer_contact_no_one":"9916481410","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"niranjan.pabbathi@gmail.com","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"uuuu","customer_query_follow_up_on":"2022-03-02 19:13:05","total_lead_time":1641,"documentCount":0},{"customer_query_id":"31","customer_query_number":"KNS31","customer_query_booking":"883","customer_query_title":"hhhh","customer_query_detail":"mmmm","customer_query_status":"1","customer_query_added_by":"2757","customer_query_added_on":"2022-03-02 13:07:20","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"353","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-AUG-JAG-17104","booked_customer_name":"Shashidhar Shetty","crm_customer_contact_no_one":"8494951190","crm_customer_contact_no_two":"8494951190","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":0},{"customer_query_id":"30","customer_query_number":"KNS30","customer_query_booking":"883","customer_query_title":"i am testing Web app","customer_query_detail":"Customer Web App","customer_query_status":"1","customer_query_added_by":"2757","customer_query_added_on":"2022-03-02 13:06:00","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"353","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-AUG-JAG-17104","booked_customer_name":"Shashidhar Shetty","crm_customer_contact_no_one":"8494951190","crm_customer_contact_no_two":"8494951190","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":0},{"customer_query_id":"29","customer_query_number":"KNS29","customer_query_booking":"883","customer_query_title":"i am testing Web app","customer_query_detail":"Customer Web App","customer_query_status":"1","customer_query_added_by":"2757","customer_query_added_on":"2022-03-02 13:05:24","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"353","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-AUG-JAG-17104","booked_customer_name":"Shashidhar Shetty","crm_customer_contact_no_one":"8494951190","crm_customer_contact_no_two":"8494951190","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":0},{"customer_query_id":"28","customer_query_number":"KNS28","customer_query_booking":"883","customer_query_title":"i am testing","customer_query_detail":"Custoemr APP in Web","customer_query_status":"1","customer_query_added_by":"2757","customer_query_added_on":"2022-03-02 12:56:25","customer_query_assigned_to":"","customer_query_assigned_on":"1970-01-01 01:01:01","crm_site_no":"353","status_name":"Katha Transfer","project_name":"ANIRVAN PHASE - 1","project_id":"1","enquiry_number":"KNS-AUG-JAG-17104","booked_customer_name":"Shashidhar Shetty","crm_customer_contact_no_one":"8494951190","crm_customer_contact_no_two":"8494951190","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"1","customer_query_status_name":"New","customer_query_assigned_to_user_name":null,"customer_query_follow_up_remark":"","customer_query_follow_up_on":"","total_lead_time":1641,"documentCount":1},{"customer_query_id":"27","customer_query_number":"KNS27","customer_query_booking":"71","customer_query_title":"electrical issue","customer_query_detail":"power issue","customer_query_status":"3","customer_query_added_by":"3241","customer_query_added_on":"2022-02-24 16:01:44","customer_query_assigned_to":"158270827163566700","customer_query_assigned_on":"2022-02-24 16:07:04","crm_site_no":"91","status_name":"Katha Transfer","project_name":"UNNATI PHASE - 2","project_id":"4","enquiry_number":"KNS-DEC-VEN-9523","booked_customer_name":"TEST","crm_customer_contact_no_one":"7406544111305","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"AS@AD.IN","customer_query_status_name":"In Progress","customer_query_assigned_to_user_name":"SHANKAR P TOLI","customer_query_follow_up_remark":"No no","customer_query_follow_up_on":"2023-02-03 17:00:34","total_lead_time":1647,"documentCount":0},{"customer_query_id":"25","customer_query_number":"KNS25","customer_query_booking":"71","customer_query_title":"katha,tax ","customer_query_detail":"katha,tax documents are not received ","customer_query_status":"2","customer_query_added_by":"2757","customer_query_added_on":"2022-02-18 15:36:43","customer_query_assigned_to":"160690053511027000","customer_query_assigned_on":"2022-02-18 15:37:16","crm_site_no":"91","status_name":"Katha Transfer","project_name":"UNNATI PHASE - 2","project_id":"4","enquiry_number":"KNS-DEC-VEN-9523","booked_customer_name":"TEST","crm_customer_contact_no_one":"7406544111305","crm_customer_contact_no_two":"","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"AS@AD.IN","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"JYOTHI.D","customer_query_follow_up_remark":"when it's soon","customer_query_follow_up_on":"2022-02-18 16:17:02","total_lead_time":1653,"documentCount":1},{"customer_query_id":"24","customer_query_number":"KNS1","customer_query_booking":"3569","customer_query_title":"dd","customer_query_detail":"dd","customer_query_status":"2","customer_query_added_by":"3368","customer_query_added_on":"2022-02-18 15:04:09","customer_query_assigned_to":"157224352626450200","customer_query_assigned_on":"2022-02-21 11:33:43","crm_site_no":"526","status_name":"Katha Transfer","project_name":"OZONE KNS OASIS PHASE - B","project_id":"8","enquiry_number":"KNS-R-SEP-PRU-143650","booked_customer_name":"Mr. Rupesh Sjngh","crm_customer_contact_no_one":"9449726429","crm_customer_contact_no_two":"7759836670","crm_customer_contact_no_three":"","crm_customer_contact_no_four":"","crm_customer_email_id_one":"singh09rupesh@gmail.com","customer_query_status_name":"Assigned","customer_query_assigned_to_user_name":"ARPITHA.TN","customer_query_follow_up_remark":"after 10 hgghj","customer_query_follow_up_on":"2022-05-21 11:51:16","total_lead_time":1653,"documentCount":0}]}