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 | 545 | 9/15/2020 9:51:44 AM | 7/21/2021 7:52:08 AM | Water query | no valid query details submitted | 27 | 3 | 774 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:17:05.008Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:53:14.511Z"}] | 1 | 44 | 7/21/2021 7:52:08 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 544 | 9/15/2020 9:48:07 AM | 7/21/2021 7:51:27 AM | Water query | no valid query details submitted | 27 | 3 | 773 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:16:39.032Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:52:29.502Z"}] | 1 | 44 | 7/21/2021 7:51:27 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 543 | 9/15/2020 9:40:28 AM | 7/21/2021 8:09:51 AM | Water query | no valid query details submitted | 27 | 3 | 772 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:25:56.522Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:10:52.964Z"}] | 1 | 44 | 7/21/2021 8:09:51 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 542 | 9/15/2020 9:29:26 AM | 7/21/2021 9:02:33 AM | Water query | no valid query details submitted | 27 | 3 | 771 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:26:19.887Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:01:49.301Z"}] | 1 | 44 | 7/21/2021 9:02:33 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 541 | 9/15/2020 9:24:09 AM | 10/12/2021 1:40:58 PM | Water query | no valid query details submitted<div><span lang="EN-GB" style="font-size:11.0pt;font-family: "Calibri",sans-serif;mso-fareast-font-family:Calibri;mso-fareast-theme-font: minor-latin;mso-ansi-language:EN-GB;mso-fareast-language:EN-ZA;mso-bidi-language: AR-SA"><b>1.Investigate Large water bill,</b></span></div><div><span style="font-family: Calibri, sans-serif; font-size: 11pt;"><b> 2. meter removed, not able to correspond reading with meter. </b></span></div> | 30 | 3 | 770 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:02:24.307Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:15:24.251Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-12T13:36:18.117Z"}] | 1 | 112 | 230 | 14 | 230 | ||||||||||||||||||||||
| 0 | 540 | 9/15/2020 9:20:09 AM | 7/21/2021 8:22:04 AM | Water query | no valid query details submitted | 27 | 3 | 769 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:10:03.318Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:21:58.180Z"}] | 1 | 44 | 7/21/2021 8:22:04 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 539 | 9/14/2020 4:16:12 PM | 10/27/2021 9:33:47 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 | 768 | 33 | 33 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:33:22.557Z"}] | 9 | 123 | 14 | 10/27/2021 9:33:47 AM | 33 | 33 | 14 | |||||||||||||||||||
| 0 | 538 | 9/14/2020 1:43:06 PM | 3/28/2022 7:08:29 AM | apply 6 months policy 20180825 | <b>Response from QRC :</b><div>Journal Number :826711</div><div>Journal Authorised.</div> | 27 | 3 | 767 | 6 | 6 | 2 | 23 | 1 | 101 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:17:22.209Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:19:35.699Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:20:00.405Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:20:42.310Z"}] | 1 | 101 | 3/28/2022 7:08:29 AM | 6 | 6 | 230 | ||||||||||||||||||||
| 0 | 537 | 9/14/2020 1:05:30 PM | 4/12/2022 9:39: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 | 766 | 34 | 4 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-29T06:50:29.849Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-06-02T09:09:59.588Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:21:39.137Z"}] | 9 | 123 | 14 | 4/12/2022 9:39:10 AM | 4 | 34 | 14 | |||||||||||||||||||
| 0 | 133814 | 536 | 9/14/2020 8:53:36 AM | 2/24/2022 11:21:35 AM | Water Query | Consumer is querying water charge for the month of February and March, please correct the account | 27 | 3 | 765 | 9 | 9 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:19:45.637Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T08:55:27.696Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-05T07:31:27.579Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-05T07:34:16.049Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-05T07:48:20.479Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-05T07:53:41.722Z"}] | 1 | 101 | 4 | 2/24/2022 11:21:35 AM | 9 | 9 | 4 | ||||||||||||||||||
| 0 | 535 | 9/14/2020 8:08:36 AM | 3/28/2022 6:35:04 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 | 764 | 5 | 5 | 2 | 23 | 3 | 52 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T06:41:39.728Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:17:45.984Z"}] | 9 | 123 | 14 | 3/28/2022 6:35:04 AM | 5 | 5 | 14 | |||||||||||||||||||
| 0 | 132977 | 534 | 9/13/2020 7:16:05 AM | 2/23/2023 8:02:25 AM | Water Query | Consumer is querying high water consumption for the month of April 2020 and August 2020, please correct the account.<div><br></div><div>Account is affected with punitive tariffs. Consumer to be advised to check for leaks</div> | 27 | 3 | 763 | 9 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:16:32.046Z"}] | 1 | 101 | 14 | 2/23/2023 8:02:24 AM | 143060 | 13 | 9 | 13 | ||||||||||||||||||
| 0 | 533 | 9/11/2020 10:38:01 AM | 3/2/2022 7:53:56 AM | Log Query | journal done | 27 | 3 | 762 | 34 | 34 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:00:31.137Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:03:40.146Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T08:54:46.354Z"}] | 1 | 101 | 6 | 3/2/2022 7:53:56 AM | 34 | 34 | 6 | |||||||||||||||||||
| 0 | 532 | 9/11/2020 9:20:44 AM | 3/2/2022 7:53:56 AM | Log Query | El reading updated 31/07/2021 | 27 | 3 | 761 | 34 | 34 | 2 | 23 | 2 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-14T08:17:04.113Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-14T08:17:51.921Z"}] | 2 | 44 | 3/2/2022 7:53:56 AM | 34 | 34 | 12 | ||||||||||||||||||||
| 0 | 531 | 9/11/2020 9:10:25 AM | 3/2/2022 7:53:56 AM | Log Query | electricity readings updated<div>2020/02/26</div> | 27 | 3 | 760 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-14T08:15:52.072Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-14T08:16:33.706Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-14T08:16:50.379Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:12:12.456Z"}] | 2 | 111 | 17 | 3/2/2022 7:53:56 AM | 34 | 34 | 17 | |||||||||||||||||||
| 0 | 530 | 9/11/2020 9:07:26 AM | 3/2/2022 7:53:56 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 | 759 | 34 | 34 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-23T08:23:34.657Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:15:00.152Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 118749 | 34 | 34 | 14 | ||||||||||||||||||
| 0 | 131771 | 529 | 9/11/2020 8:50:17 AM | 10/14/2021 10:08:14 AM | WATER QUERY | Please check readings ,consumer is complaining about a high bill for the month of August and Septemeber.<div>Journal Done</div> | 27 | 3 | 758 | 32 | 32 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:41:26.511Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:07:51.001Z"}] | 1 | 101 | 17 | 10/14/2021 10:08:14 AM | 32 | 32 | 17 | ||||||||||||||||||
| 0 | 528 | 9/11/2020 8:45:33 AM | 3/2/2022 7:53:56 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 | 757 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:13:24.188Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 527 | 9/11/2020 8:30:55 AM | 4/12/2022 9:43:30 AM | high water consumption | readings uptodate | 27 | 3 | 756 | 7 | 7 | 2 | 23 | 1 | 48 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:23:10.010Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:24:37.069Z"}] | 1 | 48 | 4/12/2022 9:43:30 AM | 7 | 7 | 12 | ||||||||||||||||||||
| 0 | 131425 | 526 | 9/11/2020 6:13:39 AM | 9/11/2020 6:13:40 AM | Log Query | Please check readings, the consumer is complaining about a high water bill. | 6 | 2 | 32 | 77 | 77 | 32 |