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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 228 | 7/15/2020 11:27:23 AM | 7/15/2020 11:27:26 AM | Balance Enquiry | 7 | 2 | 339 | 39 | 39 | 78 | 78 | 7/15/2020 11:27:26 AM | 39 | 39 | |||||||||||||||||||||||||||
| 0 | 227 | 7/15/2020 11:01:49 AM | 10/23/2021 9:14:30 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 338 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:13:33.673Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:14:26.216Z"}] | 9 | 123 | 14 | 10/23/2021 9:14:30 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 226 | 7/15/2020 10:58:26 AM | 10/23/2021 9:10:27 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 337 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:02:47.111Z"}] | 9 | 123 | 14 | 10/23/2021 9:10:27 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 225 | 7/15/2020 10:57:13 AM | 10/23/2021 9:02:15 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 336 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-06T08:26:14.001Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:00:56.850Z"}] | 9 | 123 | 14 | 10/23/2021 9:02:15 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 224 | 7/15/2020 10:55:48 AM | 10/23/2021 9:00:39 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 335 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:58:24.551Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:00:35.111Z"}] | 9 | 123 | 14 | 10/23/2021 9:00:39 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 223 | 7/15/2020 10:53:28 AM | 10/23/2021 8:57:16 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 334 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:50:59.810Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:57:11.635Z"}] | 9 | 123 | 14 | 10/23/2021 8:57:16 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 222 | 7/15/2020 10:51:53 AM | 10/13/2021 9:52:36 AM | water query | o/r june 2020 | 27 | 3 | 333 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:49:19.930Z"}] | 1 | 111 | 17 | 10/13/2021 9:52:36 AM | 39 | 39 | 17 | ||||||||||||||||||||
| 0 | 221 | 7/15/2020 8:52:58 AM | 11/11/2021 6:35:50 AM | WATER HIGH CONSUMPTION/SIX MONTHS | INTERIMS BILLED ON THE ACCOUNT,KINDLY INVESTIGATE AND RESOLVE. | 23 | 3 | 332 | 39 | 2 | 1 | 1 | 47 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-06T08:03:26.362Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:38:43.212Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:42:13.139Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-11T06:35:34.109Z"}] | 1 | 101 | 13 | 39 | 13 | ||||||||||||||||||||||
| 0 | 69879 | 220 | 7/14/2020 10:37:00 AM | 2/25/2022 9:22:48 AM | Log Query | pls correct acc.<table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 4667 | 41 | 41 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:04:43.156Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:36:58.953Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:38:02.767Z"}] | 9 | 123 | 14 | 2/25/2022 9:22:48 AM | 41 | 41 | 14 | ||||||||||||||||||
| 0 | 219 | 7/13/2020 11:37:00 AM | 10/14/2021 7:11:51 AM | Log Query | OVER READ DONE | 27 | 3 | 331 | 39 | 39 | 3 | 23 | 1 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-14T07:11:18.472Z"}] | 1 | 96 | 11 | 10/14/2021 7:11:51 AM | 39 | 39 | 11 | ||||||||||||||||||||
| 0 | 218 | 7/13/2020 11:11:23 AM | 10/16/2021 10:29:37 AM | Log Query | <div xuse-input="" xinput-debounce="100" fillmask="true" class="q-field__native row items-center" style="line-height: 18px; text-decoration-style: initial; text-decoration-color: initial; text-transform: none; background-color: rgb(255, 255, 255); padding-top: 0px; padding-bottom: 2px; width: 320.281px; min-height: 24px; font-size: 14px;">No Water Charged<div id="f_df94d2ed-9668-4d65-b42b-48ec697ccd47" tabindex="0" role="combobox" aria-multiselectable="false" aria-expanded="false" aria-owns="f_df94d2ed-9668-4d65-b42b-48ec697ccd47_lb" aria-activedescendant="f_df94d2ed-9668-4d65-b42b-48ec697ccd47_-1" class="no-outline" aria-invalid="false"></div></div><div class="q-field__label no-pointer-events absolute ellipsis" style="right: -106.75px; top: 10px; color: rgb(2, 123, 227); font-size: 14px; text-decoration-style: initial; text-decoration-color: initial; text-transform: none; transition-duration: 0.36s, 0.396s; transform: translateY(-30%) scale(0.75); background-color: rgb(255, 255, 255);">Sub-Category</div> | 27 | 3 | 330 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T10:27:00.498Z"}] | 1 | 113 | 4 | 10/16/2021 10:29:37 AM | 39 | 39 | 4 | ||||||||||||||||||||
| 0 | 217 | 7/13/2020 10:30:13 AM | 11/10/2021 12:07:49 PM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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> | 27 | 3 | 329 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:34:39.752Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:36:13.934Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T12:07:36.169Z"}] | 9 | 123 | 6 | 11/10/2021 12:07:49 PM | 39 | 39 | 6 | ||||||||||||||||||||
| 0 | 216 | 7/13/2020 7:09:12 AM | 10/17/2021 8:33:38 AM | Log Query | ACCOUNT INORDER | 27 | 3 | 328 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T08:32:50.823Z"}] | 1 | 96 | 6 | 10/17/2021 8:33:38 AM | 39 | 39 | 6 | ||||||||||||||||||||
| 0 | 215 | 7/12/2020 9:59:26 AM | 4/12/2022 9:47:18 AM | 6 month policy | 6 month policy - adjust and assess<div><br></div><div>Six month Policy: Processed ,<b>Journal Number</b>: [368935]</div><div><br></div><div><b>RESPONSE QRC</b>: Six month Policy 2020/08</div><div><br></div><div><br></div><br><br> | 27 | 3 | 327 | 10 | 75 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:33:20.135Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T12:12:42.644Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T12:16:46.647Z"}] | 1 | 101 | 230 | 4/12/2022 9:47:18 AM | 173 | 10 | 230 | |||||||||||||||||||
| 0 | 214 | 7/12/2020 8:47:07 AM | 2/21/2023 8:41:28 AM | 6 month policy | 6 month policy to be adjusted and assessed.<br><b>Journal Number</b>: [bj71826761]<div><br></div><div>QRC Response - account benefited from indigent subsidy write offs</div> | 27 | 3 | 326 | 10 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:54:43.819Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:26:37.387Z"}] | 1 | 101 | 14 | 2/21/2023 8:41:27 AM | 142979 | 13 | 10 | 13 | ||||||||||||||||||
| 0 | 213 | 7/12/2020 6:51:22 AM | 4/12/2022 9:47:18 AM | 6 month policy | 6 month policy to be adjusted and assessed.<div>6 months policy done 20200727</div> | 27 | 3 | 325 | 10 | 10 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:15:39.016Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:17:03.603Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-10-18T02:50:37.484Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-10-18T02:59:00.347Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:25:31.824Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T10:19:55.662Z"}] | 1 | 101 | 6 | 4/12/2022 9:47:18 AM | 10 | 10 | 6 | |||||||||||||||||||
| 0 | 212 | 7/12/2020 6:41:22 AM | 4/12/2022 9:47:18 AM | 6 monthpolicy | 6 month policy to be assessed and adjusted.<div>account closed</div> | 27 | 3 | 324 | 10 | 10 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:22:47.404Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T10:15:44.390Z"}] | 1 | 101 | 6 | 4/12/2022 9:47:18 AM | 10 | 10 | 6 | |||||||||||||||||||
| 0 | 211 | 7/11/2020 7:34:04 AM | 2/24/2022 11:16:33 AM | Log Query | CONSUMER INQUIRED WHY HER WATER CONSUMPTION IS SO HIGH AFTER BEING AVERAGED OVER A PERIOD OF TIME.<div>Resolution</div><div>Acc affected with stage 3 punitive tarriff, it is advisable for the consumer to check for leaks or try and reduce consumption.</div><div>High consumption call logged with control number 751737 </div> | 27 | 3 | 323 | 23 | 23 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-04T12:53:46.754Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-28T06:32:26.707Z"}] | 1 | 67 | 2/24/2022 11:16:33 AM | 23 | 23 | 17 | ||||||||||||||||||||
| 0 | 210 | 7/11/2020 6:27:31 AM | 2/24/2022 11:12:21 AM | Log Query/ water query leak repaired | CONSUMER TO SEND PLUMBERS LETTER.<table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 322 | 25 | 25 | 2 | 23 | 1 | 49 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-05-28T09:49:25.270Z"},{"op":"R","uid":"25","un":"ernelizef","dt":"2021-07-05T09:35:14.523Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-04T11:49:02.917Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:20:28.846Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T08:22:15.579Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-11-05T09:31:18.481Z"}] | 9 | 123 | 14 | 2/24/2022 11:12:21 AM | 25 | 25 | 14 | |||||||||||||||||||
| 0 | 209 | 7/10/2020 8:52:03 AM | 3/28/2022 7:23:36 AM | 100% | water works recommended 100% to be done <br/><b>Journal Number</b>: [804799] | 27 | 3 | 321 | 13 | 75 | 2 | 23 | 1 | 49 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-05-28T09:25:13.807Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-14T09:54:05.428Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-19T09:21:01.464Z"}] | 1 | 49 | 3/28/2022 7:23:36 AM | 173 | 13 | 12 |