Total Items: 106116
| EscalationLevel | LatestCall | LatestChat | LatestSms | LatestEmail | LatestFax | Campaign | IsOpen | Customer | LatestTicket | CreatedAt | UpdatedAt | Subject | Description | Priority | Disposition | ConversationType | Parent | Account | OpenedBy | AssignedTo | Region | Department | QueryType | SubQueryType | Escalation | EscalationCron | History | CreatedBy | UpdatedBy | Category | Subcategory | CreatedBy1 | UpdatedBy1 | ResolvedAt | Thread | ResolvedBy | WasCreatedByCustomer | HasIvrcall | Creator | Updator | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2853 | 3/29/2021 12:34:07 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2493 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:34:09.321Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2852 | 3/29/2021 12:28:40 PM | 5/19/2022 7:53:10 AM | WATER QUERY | <table border="0" cellpadding="0" cellspacing="0" width="770" style="border-collapse: collapse;width:578pt"> <colgroup><col width="770" style="mso-width-source:userset;mso-width-alt:24640;width:578pt"> </colgroup><tbody><tr height="21" style="height:15.75pt"> <td height="21" class="xl65" width="770" style="height:15.75pt;width:578pt">Query is being voided as no details of query were logged, query was logged only as "Log Query" with no category</td> </tr> <tr height="21" style="height:15.75pt"> <td height="21" class="xl66" width="770" style="height:15.75pt;width:578pt">selected . New query to be logged with full information fo query</td> </tr></tbody></table> | 4 | 3 | 2492 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-29T12:29:00.397Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:21:33.187Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:22:05.873Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2851 | 3/29/2021 12:26:45 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2491 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:26:47.604Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2850 | 3/29/2021 12:21:26 PM | 5/27/2021 4:24:21 AM | water | <span style="background-color: rgb(255, 255, 255);">old water meter closed.</span> | 27 | 3 | 2490 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:21:30.677Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2849 | 3/29/2021 12:19:44 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2489 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:19:46.370Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2848 | 3/29/2021 12:15:54 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2488 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:15:56.745Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2847 | 3/29/2021 12:13:29 PM | 9/28/2022 12:24:47 PM | Leak Credit | Kindly assess a leakage that was fixed in 2020/11 <div><br></div><div>Leak credit passed on account</div><br/><b>Journal Number</b>: [560283]<br/><b>Journal Amount</b>: [3674,38] | 25 | 3 | 2487 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T12:13:31.515Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:20:35.372Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:20:57.439Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:33:20.561Z"}] | 1 | 96 | 18 | 9/28/2022 12:24:46 PM | 8 | 8 | ||||||||||||||||||||||
| 2846 | 3/29/2021 12:08:29 PM | 8/21/2021 7:50:54 AM | water | check reading requested. | 27 | 3 | 2486 | 12 | 2 | 23 | 1 | 47 | 1265 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:08:31.386Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:51:27.896Z"}] | 1 | 47 | 8/21/2021 7:50:54 AM | 12 | 12 | ||||||||||||||||||||||
| 2845 | 3/29/2021 12:04:39 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2485 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:04:52.825Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2844 | 3/29/2021 11:56:21 AM | 2/20/2022 6:44:57 AM | Leak Credit | Kindly assess a leak credit, for a leak that started in 11/2020<div><br></div><div>PLUMBERS LETTER MUST BE SUBMITTED</div><div>consumption still high after repairs date, consumer must look for another leak and fix then submit the invoice or letter.</div> | 27 | 3 | 2484 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T12:08:11.698Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:19:31.931Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:20:20.956Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:32:21.626Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-20T06:43:27.916Z"}] | 1 | 96 | 17 | 2/20/2022 6:44:57 AM | 124253 | 172 | 17 | |||||||||||||||||||||
| 2843 | 3/29/2021 10:58:17 AM | 11/21/2021 9:05:05 AM | no valid query details submitted | no valid query details submitted | 4 | 3 | 2483 | 13 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T10:54:59.849Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:54:33.011Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:54:27.701Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T08:55:46.403Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-21T09:03:48.094Z"}] | 1 | 44 | 11/21/2021 9:05:05 AM | 13 | 3 | |||||||||||||||||||||||
| 2842 | 3/29/2021 10:52:20 AM | 11/21/2021 10:32:56 AM | Leak Credit | Kindly assess a leak credit that was reported on the 5th October 2019<br/><b>Journal Amount</b>: [12873.08] | 27 | 3 | 2482 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T10:50:23.119Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:18:12.729Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:18:30.442Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-11-12T13:20:13.631Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-11-21T10:32:36.573Z"}] | 1 | 96 | 8 | 11/21/2021 10:32:56 AM | 119694 | 172 | 8 | |||||||||||||||||||||
| 2841 | 3/29/2021 10:48:40 AM | 2/2/2022 12:28:44 PM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:48:43.655Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:17:46.394Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:38:49.629Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:39:13.207Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2840 | 3/29/2021 10:36:54 AM | 2/2/2022 12:28:44 PM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:37:12.945Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:17:19.829Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:18:23.400Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2839 | 3/29/2021 10:34:38 AM | 2/2/2022 12:28:44 PM | High water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:34:41.373Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:16:16.907Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:16:40.460Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:16:48.706Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2838 | 3/29/2021 10:32:53 AM | 2/2/2022 12:28:44 PM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 1 | 67 | 1261 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:32:54.845Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:15:38.198Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:15:18.793Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:15:28.744Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 2837 | 3/29/2021 10:31:18 AM | 2/2/2022 12:28:44 PM | High water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:31:20.186Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:15:05.209Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:13:57.768Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:14:11.824Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2836 | 3/29/2021 10:29:39 AM | 2/2/2022 12:28:44 PM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:29:41.421Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:14:36.487Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T12:48:27.154Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:55:33.474Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:55:46.532Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2834 | 3/29/2021 10:27:38 AM | 2/2/2022 12:28:44 PM | High water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 4 | 23 | 1 | 67 | 1258 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-29T10:27:40.561Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:13:59.589Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:47:05.648Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:47:52.160Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 2835 | 3/29/2021 10:27:26 AM | 5/27/2021 4:24:21 AM | water | old meter closed. | 27 | 3 | 2481 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T10:27:28.060Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 |