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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2831 | 3/29/2021 10:18:54 AM | 5/27/2021 4:24:21 AM | water | old water meter closed | 27 | 3 | 2479 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T10:18:56.620Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2832 | 3/29/2021 10:13:03 AM | 2/20/2022 10:51:55 AM | Leak Credit | Assess a leak credit for an invoice dated 12/6/2020<div><br></div><div>CONSUMPTION TILL HIGH AFTER 3 MONTHS BUT DROP IN 2021 AND 2022 </div><div>IF THE IS ANOTHER LEAK THAT WAS FIXED PLUMBERS LETTER MUST BE SUBMITTED.</div> | 30 | 3 | 2480 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T10:13:29.415Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:53:48.777Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:12:28.376Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:13:41.317Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:41:55.245Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T10:49:17.891Z"}] | 1 | 96 | 4 | 124269 | 4 | ||||||||||||||||||||||||
| 2826 | 3/29/2021 10:06:32 AM | 5/19/2022 7:51:12 AM | Late Termination Query | Consumer sold the Property. Kindly terminate services.<div>Regitration date 2020/11 billing Coastal region to terminate<br></div> | 27 | 3 | 2475 | 16 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-29T10:06:52.856Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:19:40.995Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:20:14.646Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:34:41.501Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:43:35.014Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-08T09:40:27.531Z"}] | 77 | 107 | 5/19/2022 7:51:12 AM | 16 | 172 | |||||||||||||||||||||||
| 2832 | 3/29/2021 10:05:35 AM | 2/20/2022 10:49:07 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2480 | 11 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T10:05:54.999Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T10:13:21.861Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:55:18.605Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:52:59.156Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:41:38.295Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T10:48:46.904Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T10:49:07.369Z"}] | 1 | 44 | 2/20/2022 10:49:07 AM | 11 | 4 | |||||||||||||||||||||||
| 2830 | 3/29/2021 9:37:55 AM | 11/14/2021 11:30:19 AM | water | billing to close old meter<div>Journal Done</div> | 27 | 3 | 2478 | 12 | 2 | 23 | 1 | 46 | 1257 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T09:37:57.736Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T09:31:25.560Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:30:19.414Z"}] | 1 | 96 | 17 | 11/14/2021 11:30:19 AM | 12 | 17 | |||||||||||||||||||||
| 2829 | 3/29/2021 9:31:08 AM | 5/27/2021 4:24:21 AM | water | water old meter closed | 27 | 3 | 2477 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T09:31:09.954Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2828 | 3/29/2021 9:30:58 AM | 5/13/2022 10:05:39 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2476 | 6 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T09:31:17.623Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:55:48.568Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:08:19.735Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-05-13T10:05:38.321Z"}] | 1 | 44 | 5/13/2022 10:05:39 AM | 6 | 203 | |||||||||||||||||||||||
| 2826 | 3/29/2021 9:26:45 AM | 3/29/2021 9:26:48 AM | 2 | 2475 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-29T09:27:05.152Z"}] | 16 | |||||||||||||||||||||||||||||||||||
| 2827 | 3/29/2021 9:26:11 AM | 5/27/2021 4:24:21 AM | water | old meter closed | 27 | 3 | 2474 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T09:26:19.310Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-07T13:01:31.225Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 2 | |||||||||||||||||||||||
| 2825 | 3/29/2021 9:23:32 AM | 10/17/2021 8:53:28 AM | water | billing to close old meter<div>old meter closed ,new meter updated.</div> | 27 | 3 | 2473 | 12 | 2 | 23 | 1 | 45 | 1256 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T09:23:33.905Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T07:26:04.655Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T08:53:29.277Z"}] | 1 | 112 | 12 | 10/17/2021 8:53:28 AM | 12 | 12 | |||||||||||||||||||||
| 2823 | 3/29/2021 9:19:54 AM | 10/17/2021 8:52:25 AM | water | billing to close old meter.<div>ACCOUNT IN ORDER</div> | 27 | 3 | 2472 | 12 | 2 | 23 | 1 | 45 | 1255 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T09:19:56.325Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T08:51:55.345Z"}] | 1 | 50 | 12 | 10/17/2021 8:52:25 AM | 12 | 12 | |||||||||||||||||||||
| 2822 | 3/29/2021 9:15:27 AM | 5/19/2022 7:53:10 AM | CHANGE OF OWNERSHIP | CHANGE OF OWNERSHIP | 27 | 3 | 2471 | 18 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-29T09:15:46.520Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:56:15.553Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:24:18.093Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:19:29.308Z"}] | 77 | 107 | 5/19/2022 7:53:10 AM | 18 | 11 | |||||||||||||||||||||||
| 2821 | 3/29/2021 9:12:25 AM | 6/30/2022 1:26:26 PM | Leak Credit | Kindly assess a water leak for an inspection done on the 20/08/2020<div><br></div><div>leak credit passed on account</div><br/><b>Journal Number</b>: [902084] | 27 | 3 | 2470 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T09:12:44.848Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:08:41.564Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:11:14.089Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:11:39.028Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:12:06.131Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-12-06T07:44:35.610Z"},{"op":"R","uid":"904","un":"vuyelwamx","dt":"2022-04-26T06:25:01.951Z"}] | 1 | 96 | 11 | 6/30/2022 1:26:25 PM | 134174 | 7 | 7 | |||||||||||||||||||||
| 2818 | 3/29/2021 8:57:23 AM | 3/29/2021 9:01:50 AM | 2 | ||||||||||||||||||||||||||||||||||||||
| 2814 | 3/29/2021 8:16:50 AM | 11/14/2021 11:29:25 AM | Leak Credit | Kindly assess a leak that was reported in June 2020 | 27 | 3 | 2469 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T08:17:10.111Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:05:04.026Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:07:24.123Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:08:07.440Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:28:03.731Z"}] | 1 | 96 | 4 | 11/14/2021 11:29:25 AM | 172 | 4 | ||||||||||||||||||||||
| 2813 | 3/29/2021 8:13:37 AM | 7/21/2021 10:07:38 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 15 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T08:13:57.934Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:56:16.890Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:07:39.460Z"}] | 1 | 44 | 7/21/2021 10:07:38 AM | 15 | 14 | ||||||||||||||||||||||||
| 2810 | 3/29/2021 8:05:18 AM | 5/27/2021 4:24:21 AM | old water meter closed | water | 27 | 3 | 2468 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T08:05:23.542Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2809 | 3/29/2021 8:05:09 AM | 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 | 2467 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-29T08:05:31.696Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:12:45.451Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:58:52.949Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:59:24.408Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:00:27.713Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-03-31T06:54:04.757Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2808 | 3/29/2021 8:00:56 AM | 3/28/2022 6:35:04 AM | Water not billed on Account | Water not billed on owner's account. Kindly investigate and resolve.<br/><b>Journal Amount</b>: [239510] | 25 | 3 | 2466 | 5 | 2 | 23 | 1 | 58 | 1967 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-29T08:00:58.063Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-29T08:03:29.189Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-11T13:11:33.099Z"}] | 1 | 58 | 3/28/2022 6:35:04 AM | 5 | 5 | ||||||||||||||||||||||
| 2807 | 3/29/2021 7:56:44 AM | 10/25/2021 8:57:02 AM | water | <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> | 27 | 3 | 2465 | 12 | 2 | 23 | 1 | 65 | 1251 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T07:56:46.381Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:57:03.615Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:57:47.917Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-25T08:56:51.979Z"}] | 9 | 123 | 4 | 10/25/2021 8:57:02 AM | 12 | 4 |