{"iTotalDisplayRecords":"9","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `id`, `project`, `message_type`, `message_subject`, `message_body`, `remark`, `added_by`, `added_on`, `project_name`, `added_user_name`\r\n    FROM customer_message_view\r\n    \r\n    ORDER BY message_type ASC\r\n    \r\n    ","aaData":[{"id":"50","project":"27","message_type":"Email","message_subject":"Test","message_body":"<p><em><strong>TestBody<\/strong><\/em><\/p>\r\n","remark":"  Booking  Registration  Katha Transfer ","added_by":"143620071466608200","added_on":"2023-06-07 15:46:23","project_name":"KNS ETHOS II","added_user_name":"NANJEGOWDA","documentCount":2},{"id":"49","project":"30","message_type":"Email","message_subject":"Test Subject","message_body":"<p><br \/>\r\n<em>Greetings from KNS Infrastructure Pvt Ltd&hellip;!!!<br \/>\r\n<br \/>\r\nWe hope you are doing well. We are writing this mail to inform you about the maintenance of the Ozone KNS Oasis project, will end by July 2023.<br \/>\r\n<br \/>\r\nFurthermore, we would like to offer our assistance in forming an association if you have not already done so. We understand that having an association is essential for the smooth operation of the project, and we are happy to assist you with bye-laws for the association. If an association has already been established, we will acknowledge it.<br \/>\r\nwe believe that this initiative will be helpful for all the plot owners of the project.<br \/>\r\nThank you for your ongoing support and trust in our services.<br \/>\r\n<br \/>\r\nWarm Regards,<br \/>\r\n<strong>KNS Infrastructure Pvt Ltd<\/strong><\/em><\/p>\r\n","remark":"..","added_by":"143620071466608200","added_on":"2023-06-07 12:53:26","project_name":"KNS FRESCO","added_user_name":"NANJEGOWDA","documentCount":0},{"id":"48","project":"21","message_type":"Email","message_subject":"Test","message_body":"<p><em>Dear Sir\/Madam,<\/em><\/p>\r\n\r\n<p><br \/>\r\n<em>Greetings from KNS Infrastructure Pvt Ltd&hellip;!!!<br \/>\r\n<br \/>\r\nWe hope you are doing well. We are writing this mail to inform you about the maintenance of the Ozone KNS Oasis project, will end by July 2023.<br \/>\r\n<br \/>\r\nFurthermore, we would like to offer our assistance in forming an association if you have not already done so. We understand that having an association is essential for the smooth operation of the project, and we are happy to assist you with bye-laws for the association. If an association has already been established, we will acknowledge it.<br \/>\r\nwe believe that this initiative will be helpful for all the plot owners of the project.<br \/>\r\nThank you for your ongoing support and trust in our services.<br \/>\r\n<br \/>\r\nWarm Regards,<br \/>\r\nKNS Infrastructure Pvt Ltd<\/em><\/p>\r\n","remark":"Test","added_by":"143620071466608200","added_on":"2023-06-07 12:41:34","project_name":"KNS ETHOS","added_user_name":"NANJEGOWDA","documentCount":1},{"id":"47","project":"1","message_type":"Email","message_subject":"tes test tes test tes test tes test tes test tes test tes test tes t","message_body":"tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test tes test ","remark":"tes test tes test tes test tes test tes test ","added_by":"143620071466608200","added_on":"2023-06-06 12:08:08","project_name":"ANIRVAN PHASE - 1","added_user_name":"NANJEGOWDA","documentCount":0},{"id":"46","project":"21","message_type":"Email","message_subject":"Test sub","message_body":"test body11","remark":"","added_by":"143620071466608200","added_on":"2023-06-05 13:42:55","project_name":"KNS ETHOS","added_user_name":"NANJEGOWDA","documentCount":0},{"id":"45","project":"34","message_type":"Email","message_subject":"Subject 5","message_body":" Lorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n\r\nloremLorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n","remark":"Rm5","added_by":"143620071466608200","added_on":"2023-06-05 11:31:46","project_name":"KNS LAUREL","added_user_name":"NANJEGOWDA","documentCount":0},{"id":"42","project":"14","message_type":"Email","message_subject":"Subject Subject Subject ","message_body":"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\n","remark":"rm1 ","added_by":"143620071466608200","added_on":"2023-06-03 16:18:52","project_name":"KNS JIVANZA","added_user_name":"NANJEGOWDA","documentCount":1},{"id":"44","project":"4","message_type":"WhatsApp","message_subject":"Subject Email","message_body":" Lorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n\r\nloremLorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n","remark":"Customer Message email check","added_by":"143620071466608200","added_on":"2023-06-05 11:30:43","project_name":"UNNATI PHASE - 2","added_user_name":"NANJEGOWDA","documentCount":0},{"id":"43","project":"21","message_type":"WhatsApp","message_subject":"Email Test KNS ","message_body":"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n\r\nloremLorem ipsum, dolor sit amet consectetur adipisicing elit. Eum, vero error earum sit aut quidem. Blanditiis mollitia necessitatibus ut enim aliquam quaerat consectetur illo, labore consequuntur voluptate minima totam quod.\r\n","remark":"remark ","added_by":"143620071466608200","added_on":"2023-06-03 18:12:17","project_name":"KNS ETHOS","added_user_name":"NANJEGOWDA","documentCount":0}]}