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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2393 | 3/16/2021 9:53:47 AM | 10/26/2021 11:23:33 AM | log query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2138 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T09:50:08.946Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T09:50:16.570Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T06:37:20.503Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:14:00.573Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:22:35.881Z"}] | 9 | 123 | 14 | 10/26/2021 11:23:33 AM | 14 | 14 | ||||||||||||||||||||||
| 2392 | 3/16/2021 9:37:09 AM | 10/26/2021 11:25:42 AM | log query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2137 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T09:33:30.755Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-04-21T08:55:34.221Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:17:41.552Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:24:43.849Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:25:43.243Z"}] | 9 | 123 | 14 | 10/26/2021 11:25:42 AM | 14 | 14 | ||||||||||||||||||||||
| 2391 | 3/16/2021 9:11:23 AM | 2/18/2023 6:41:50 AM | leak credit | Plumbers letters uploaded<div><b><u>QRC RESPONSE:</u></b></div><div>Leak credit journal done for 201708-201910, average 21kl.</div><br/><b>Journal Number</b>: [018164]<br/><b>Journal Amount</b>: [-R22,535.05] | 4 | 3 | 2136 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-03-16T09:07:43.597Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:26:57.532Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T09:00:50.048Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T09:01:07.241Z"}] | 1 | 96 | 14 | 2/6/2023 7:58:07 AM | 3 | 4 | ||||||||||||||||||||||
| 2390 | 3/16/2021 9:00:03 AM | 3/28/2022 7:25:06 AM | water/leak consumer submitted a plumbers letter | water/leak, <b>Journal Number</b>: [458001]<div><div><br></div><div><b>RESPONSE QRC</b>:LEAK CR,JOURNAL {458001}AUTHORISED</div><br><br></div> | 27 | 3 | 2135 | 17 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T08:56:25.012Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:27:48.190Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T08:42:18.810Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T08:07:05.034Z"}] | 1 | 96 | 230 | 3/28/2022 7:25:06 AM | 17 | 230 | ||||||||||||||||||||||
| 2389 | 3/16/2021 8:56:02 AM | 11/9/2022 12:00:11 PM | WATER LEAK CONSUMER SUBMITTED PLUMBERS LETTER | WATER LEAK CONSUMER SUBMITTED PLUMBERS LETTER<br/><b>Journal Number</b>: [880170] | 24 | 3 | 2134 | 17 | 3 | 23 | 77 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T08:52:23.691Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-08-14T07:30:39.381Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:28:52.064Z"},{"op":"R","uid":"232","un":"philiswan","dt":"2022-04-26T13:35:42.959Z"}] | 1 | 96 | 14 | 14 | ||||||||||||||||||||||||
| 2388 | 3/16/2021 8:55:12 AM | 5/17/2022 2:14:03 PM | water query | water query<div>6 months policy journal done</div><br/><b>Journal Number</b>: [566590]<br/><b>Journal Amount</b>: [-R7,585.07] | 27 | 3 | 2133 | 8 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T08:51:33.492Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:33:47.594Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-24T08:23:25.632Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:29:45.992Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:30:26.467Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-06T12:17:28.606Z"},{"op":"R","uid":"23","un":"bevins","dt":"2022-05-17T14:14:03.581Z"}] | 1 | 101 | 3 | 5/17/2022 2:14:03 PM | 8 | 3 | ||||||||||||||||||||||
| 2386 | 3/16/2021 8:46:29 AM | 10/8/2022 10:16:14 AM | water query plus plumbers letter | water query<br/><b>Journal Number</b>: [880425] | 24 | 3 | 2132 | 17 | 4 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T08:42:50.282Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T13:34:14.144Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-16T10:55:53.546Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T09:10:45.988Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:31:24.654Z"}] | 1 | 96 | 14 | 13 | ||||||||||||||||||||||||
| 2387 | 3/16/2021 8:46:15 AM | 5/19/2022 7:53:10 AM | LATE TERMINATION | LATE TERMINATION<div>previous account number 10322363 terminated </div><div>email sent to water works to confirm the water meter charged under body corporate account . </div> | 27 | 3 | 2131 | 18 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T08:42:35.940Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-24T06:51:41.503Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:32:07.662Z"}] | 6 | 76 | 12 | 5/19/2022 7:53:10 AM | 18 | 12 | ||||||||||||||||||||||
| 2385 | 3/16/2021 8:40:49 AM | 10/17/2021 6:31:37 AM | water query | water query<div><br></div><div>consumption normal no cr due</div> | 27 | 3 | 2130 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T08:37:11.465Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:39:18.165Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T06:31:14.624Z"}] | 1 | 96 | 11 | 10/17/2021 6:31:37 AM | 14 | 11 | ||||||||||||||||||||||
| 2384 | 3/16/2021 8:23:18 AM | 5/19/2022 7:53:10 AM | water query | water query<div>no query, account inorder</div> | 27 | 3 | 2129 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T08:19:39.064Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:42:32.625Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-25T07:13:07.856Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:32:50.623Z"}] | 1 | 96 | 6 | 5/19/2022 7:53:10 AM | 18 | 6 | ||||||||||||||||||||||
| 2383 | 3/16/2021 8:08:59 AM | 8/7/2021 8:46:27 AM | Late termination | Late termination | 27 | 3 | 2128 | 14 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T08:05:20.291Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:44:33.522Z"}] | 77 | 107 | 8/7/2021 8:46:27 AM | 14 | 12 | |||||||||||||||||||||||
| 2382 | 3/16/2021 8:02:56 AM | 5/19/2022 7:53:10 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2127 | 18 | 2 | 23 | 1 | 67 | 1122 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T07:59:17.638Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T07:59:36.180Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:44:47.676Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:34:18.691Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:35:42.840Z"}] | 9 | 123 | 14 | 5/19/2022 7:53:10 AM | 18 | 14 | |||||||||||||||||||||
| 2379 | 3/16/2021 7:51:55 AM | 5/19/2022 7:53:10 AM | LATE TERMINATION | LATE TERMINATION | 27 | 3 | 2126 | 18 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-16T07:48:18.894Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:47:39.633Z"}] | 6 | 107 | 5/19/2022 7:53:10 AM | 18 | 12 | |||||||||||||||||||||||
| 2380 | 3/16/2021 7:51:34 AM | 7/21/2021 9:43:08 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 5 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-16T07:52:13.213Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:07:16.895Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:42:59.442Z"}] | 1 | 44 | 7/21/2021 9:43:08 AM | 5 | 14 | ||||||||||||||||||||||||
| 2378 | 3/16/2021 7:47:14 AM | 10/17/2021 8:21:46 AM | water query | water query<div>6 month policy but interim's are more than water charge.</div> | 27 | 3 | 2125 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T07:43:35.582Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T07:56:07.684Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T07:32:38.633Z"}] | 1 | 101 | 4 | 10/17/2021 8:21:46 AM | 14 | 4 | ||||||||||||||||||||||
| 2377 | 3/16/2021 7:40:21 AM | 10/26/2021 11:37:21 AM | log query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2124 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-16T07:36:42.833Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T08:42:51.930Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:07:42.348Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:36:27.538Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:37:22.459Z"}] | 9 | 123 | 14 | 10/26/2021 11:37:21 AM | 14 | 14 | ||||||||||||||||||||||
| 2376 | 3/16/2021 7:37:59 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY | 27 | 3 | 2123 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-16T07:34:20.007Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T08:19:35.679Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-23T10:23:21.877Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:38:21.745Z"}] | 1 | 101 | 13 | 3/2/2022 8:22:38 AM | 37 | 13 | ||||||||||||||||||||||
| 2372 | 3/16/2021 7:20:19 AM | 3/9/2022 11:08:03 AM | RATES QUERY | RATES QUERY<div><br></div><div>From Rates Dpt:</div><div><table border="0" cellpadding="0" cellspacing="0" width="547" style="border-collapse: collapse;width:410pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="547" style="height:15.0pt;width:410pt">Objection finalised in 2018, the GV roll was loaded with the adjusted value.</td></tr></tbody></table></div> | 27 | 3 | 2122 | 37 | 2 | 23 | 77 | 62 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-16T07:16:42.020Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:29:30.312Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2022-03-09T11:08:04.362Z"}] | 77 | 62 | 3/9/2022 11:08:03 AM | 37 | 58 | |||||||||||||||||||||||
| 2374 | 3/16/2021 7:15:48 AM | 10/13/2021 9:40:54 AM | water query | water query<div>2020/09/14</div> | 27 | 3 | 2121 | 32 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-16T07:12:09.637Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T08:37:56.629Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:37:45.821Z"}] | 1 | 101 | 17 | 10/13/2021 9:40:54 AM | 32 | 17 | ||||||||||||||||||||||
| 2373 | 3/16/2021 7:12:28 AM | 10/16/2021 10:17:18 AM | water query | water query | 27 | 3 | 2120 | 32 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-16T07:08:49.948Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T08:26:44.881Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T10:17:01.902Z"}] | 1 | 101 | 13 | 10/16/2021 10:17:18 AM | 32 | 13 |