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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2532 | 3/23/2021 7:12:38 AM | 10/16/2021 7:30:22 AM | WATER QUERY | WATER QUERY<br/><b>Journal Number</b>: [439553] | 24 | 3 | 2237 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T07:12:40.408Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:40:41.145Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T06:43:48.492Z"}] | 1 | 101 | 13 | 13 | |||||||||||||||||||||||||
| 2531 | 3/23/2021 7:06:12 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 | 2236 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T07:06:14.088Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:43:42.221Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:15:47.983Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:26:20.179Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2530 | 3/19/2021 1:00:48 PM | 11/14/2022 1:29:57 PM | Plumbers Letter | Affidavit received for leak repairs October 2020 <div><br></div><div>QRC RESPONSE: Query Closed</div><div>Consumption has not dropped since repair dated noted in the affidavit.</div><div>Waterworks visited premises in Oct 2022 and reported a suspected underground leak at 200ml per minute.</div><div>Consumer to appoint a plumber to trace and repair all leaks.</div><div>To log a new query by uploading a signed copy of the plumbers letter stating what was repaired with date of repairs.</div> | 27 | 3 | 2235 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T13:00:51.941Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:12:25.799Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:15:05.417Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:23:25.424Z"}] | 1 | 96 | 18 | 11/14/2022 1:29:57 PM | 137538 | 3 | 3 | |||||||||||||||||||||
| 2528 | 3/19/2021 12:52:28 PM | 8/14/2021 7:20:15 AM | Plumbers letter | Leak letter received for repairs dated 2020/02<div><br></div><div>Resolved May 2021</div><div><br></div> | 27 | 3 | 2234 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T12:52:30.514Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T07:18:14.402Z"}] | 1 | 96 | 8/14/2021 7:20:15 AM | 172 | 3 | |||||||||||||||||||||||
| 2527 | 3/19/2021 12:48:08 PM | 7/21/2021 9:46:20 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 75 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T12:48:10.274Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:05:52.226Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:46:18.327Z"}] | 1 | 44 | 7/21/2021 9:46:20 AM | 173 | 14 | ||||||||||||||||||||||||
| 2526 | 3/19/2021 12:43:16 PM | 10/13/2021 9:06:44 AM | Late termination pls transfer all service to the new owner | Late termination | 27 | 3 | 2233 | 14 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-19T12:43:18.766Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-08T11:42:48.425Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-15T11:41:19.489Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:03:52.329Z"}] | 6 | 122 | 17 | 10/13/2021 9:06:44 AM | 14 | 17 | ||||||||||||||||||||||
| 2521 | 3/19/2021 12:39:23 PM | 11/5/2021 7:31:41 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 <br>Leak CR ,Processed, <b>Journal Number</b>: [479439]<br><br><b>RESPONSE QRC</b>: Leak CR Journal{479439} Authorized.</td> </tr></tbody></table><br><br> | 27 | 3 | 2232 | 12 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-19T12:39:26.211Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-11T09:49:20.844Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:09:31.945Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:10:19.971Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T07:32:23.312Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T07:34:14.742Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T07:40:51.476Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T07:28:05.234Z"}] | 9 | 123 | 230 | 11/5/2021 7:31:41 AM | 12 | 230 | ||||||||||||||||||||||
| 2525 | 3/19/2021 12:30:53 PM | 10/29/2021 9:22:59 AM | Six Months Policy | Please apply Six Months Policy for the period 2018/12 to 2020/02 | 27 | 3 | 2231 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T12:30:55.710Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:07:34.076Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:08:31.792Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T08:12:50.400Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T09:19:32.749Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T09:22:23.470Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T09:22:54.519Z"}] | 1 | 101 | 4 | 10/29/2021 9:22:59 AM | 119146 | 172 | 4 | |||||||||||||||||||||
| 2523 | 3/19/2021 12:27:33 PM | 7/21/2021 9:45:42 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 74 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T12:27:35.735Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:06:20.807Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:45:41.787Z"}] | 1 | 44 | 7/21/2021 9:45:42 AM | 172 | 14 | ||||||||||||||||||||||||
| 2522 | 3/19/2021 12:10:22 PM | 3/28/2022 6:35:04 AM | TRANSFER 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> | 4 | 3 | 2230 | 5 | 4 | 23 | 1 | 99 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-03-19T12:10:55.752Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:55:39.986Z"}] | 9 | 123 | 18 | 3/28/2022 6:35:04 AM | 5 | 18 | ||||||||||||||||||||||
| 2520 | 3/19/2021 11:48:58 AM | 2/16/2022 9:22:25 AM | 6 months back charge | <div>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.</div> | 4 | 3 | 81 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"195","un":"asandap","dt":"2021-03-19T11:49:00.946Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:54:37.518Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:23:17.144Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:23:32.217Z"}] | 9 | 123 | 14 | 2/16/2022 9:22:25 AM | 195 | 14 | |||||||||||||||||||||||
| 2519 | 3/19/2021 11:37:37 AM | 2/24/2022 11:21:35 AM | Water Query | <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 | 9 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"9","un":"masibuleley","dt":"2021-03-19T11:39:51.802Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:53:27.800Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:24:26.775Z"}] | 9 | 123 | 14 | 2/24/2022 11:21:35 AM | 9 | 14 | |||||||||||||||||||||||
| 2518 | 3/19/2021 10:15:59 AM | 10/23/2021 8:51:18 AM | water query consumer submitted a plumbers letter | water query consumer submitted plumbers letter or waterworks repairs | 30 | 3 | 2229 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-19T10:16:01.880Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-03-19T10:16:08.386Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-04T06:41:38.576Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:48:25.550Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:51:13.165Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2516 | 3/19/2021 9:45:45 AM | 10/23/2021 8:47:08 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 | 2228 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-19T09:45:47.933Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T13:02:03.673Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-04T06:42:05.352Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:45:35.215Z"}] | 9 | 123 | 18 | 10/23/2021 8:47:08 AM | 14 | 18 | ||||||||||||||||||||||
| 2515 | 3/19/2021 9:34:23 AM | 3/28/2022 7:08:29 AM | late termination 201912-202012 | late termination 201912-202012<br><b>Journal Number</b>: [470527]<div>medical aid account.</div><div><br></div><div><br></div><div><b><u>RESPONSE FROM QRC</u></b></div><div>Dog tax reversed, journal authorised 202106.</div><div>medical aid account active, consumer to consult with billing department.</div> | 27 | 3 | 2227 | 6 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-19T09:34:56.161Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:15:13.699Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T07:18:18.743Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T07:20:34.026Z"}] | 6 | 107 | 3/28/2022 7:08:29 AM | 6 | 173 | |||||||||||||||||||||||
| 2514 | 3/19/2021 9:31:41 AM | 3/28/2022 7:08:29 AM | 100% leak credit journal done | 100% leak credit journal done<br/><b>Journal Number</b>: [470503] | 27 | 3 | 2226 | 6 | 2 | 23 | 1 | 69 | 1165 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-19T09:32:14.955Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T08:56:26.235Z"}] | 1 | 96 | 17 | 3/28/2022 7:08:29 AM | 6 | 17 | |||||||||||||||||||||
| 2513 | 3/19/2021 9:28:31 AM | 3/28/2022 7:08:29 AM | 6 months policy journal done | 6 months policy journal done<br/><b>Journal Number</b>: [470473] | 27 | 3 | 2225 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-19T09:29:15.253Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:44:28.133Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:44:50.649Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T09:17:08.710Z"}] | 1 | 101 | 11 | 3/28/2022 7:08:29 AM | 6 | 11 | ||||||||||||||||||||||
| 2512 | 3/19/2021 9:17:05 AM | 3/28/2022 7:08:29 AM | 6 months policy journal done | 6 months policy journal done<br><b>Journal Number</b>: [470529]<div><b>Journal Number [826790]</b></div><div><b>Response from QRC</b></div><div>Journal Authorized.</div><div>Response from QRC</div><div><b>Query Resolved.</b></div><div><b><br></b></div> | 27 | 3 | 2224 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-19T09:17:38.851Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:09:23.837Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:12:49.861Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-30T11:31:56.977Z"}] | 1 | 101 | 3/28/2022 7:08:29 AM | 6 | 230 | |||||||||||||||||||||||
| 2510 | 3/19/2021 8:58:13 AM | 3/25/2022 8:05:15 AM | 6 Months policy | Please assess a 6 months policy for the 2019/04 billing and 2019/12 | 27 | 3 | 2223 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-19T08:58:15.127Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:43:20.618Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T08:44:06.894Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:16:50.582Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-18T13:26:25.422Z"},{"op":"R","uid":"192","un":"busisiwemr","dt":"2022-03-25T08:05:15.391Z"}] | 1 | 101 | 214 | 3/25/2022 8:05:15 AM | 172 | 214 | ||||||||||||||||||||||
| 2509 | 3/19/2021 8:51:56 AM | 7/21/2021 9:45:03 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2222 | 4 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-19T08:51:58.803Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:06:48.215Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:45:02.617Z"}] | 1 | 44 | 7/21/2021 9:45:03 AM | 4 | 14 |