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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1811 | 2/23/2021 9:25:05 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY | 27 | 3 | 1711 | 37 | 2 | 23 | 1 | 67 | 764 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:25:11.839Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-23T12:22:43.368Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:20:19.132Z"}] | 1 | 101 | 13 | 3/2/2022 8:22:38 AM | 37 | 13 | |||||||||||||||||||||
| 1810 | 2/23/2021 9:17:56 AM | 10/8/2022 10:21:32 AM | WATER QUERY | WATER QUERY 6 MONTH POLICY <div>AVE VERY HIGH ,ASKED THE CONSUMER TO SUBMIT PLUMBERS LETTER<br></div><div><br></div><div><b><u>QRC RESPONSE: </u></b>Account query is being assessed for possible spread consumption and 6 months policy.</div> | 30 | 3 | 1710 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:18:06.609Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T10:15:20.520Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-04T11:37:45.357Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T07:16:41.673Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T07:16:57.276Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T10:25:08.427Z"}] | 1 | 101 | 4 | 8 | ||||||||||||||||||||||||
| 1808 | 2/23/2021 9:09:40 AM | 3/2/2022 8:22:38 AM | ELECTRICITY QUERY | no meters on account. | 27 | 3 | 1709 | 37 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:09:46.735Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:12:26.081Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:12:54.937Z"}] | 77 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1806 | 2/23/2021 8:29:24 AM | 3/2/2022 8:22:38 AM | SEWERAGE QUERY | SEWERAGE QUERY<div><br></div><div><b><u>QRC RESPONSE:</u></b></div><div>No charge or service duplicate on account. Properrty is sold and account has been finalised accordingly.<br></div> | 27 | 3 | 1708 | 37 | 2 | 23 | 77 | 105 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T08:29:31.234Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:15:31.747Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:16:17.355Z"}] | 77 | 105 | 3/2/2022 8:22:38 AM | 37 | 8 | |||||||||||||||||||||||
| 1805 | 2/23/2021 8:24:54 AM | 2/16/2022 9:04:39 AM | HIGH WATER CONSUMPTION | HIGH WATER CONSUMPTION BILLED IN OCTOBER 2020. DEBTOR DETECTED NO LEAK. | 27 | 3 | 1707 | 82 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-02-23T08:25:12.190Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-08T06:50:53.613Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T08:58:48.100Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T08:59:12.337Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-25T09:38:25.711Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-25T09:40:46.516Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:19:41.028Z"}] | 1 | 96 | 13 | 2/16/2022 9:04:39 AM | 194 | 13 | ||||||||||||||||||||||
| 1804 | 2/23/2021 8:13:54 AM | 10/28/2021 1:19:31 PM | log query | 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. | 4 | 3 | 1706 | 39 | 4 | 23 | 77 | 44 | [{"op":"R","uid":"39","un":"tembekas","dt":"2021-02-23T08:13:56.388Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:19:21.396Z"}] | 9 | 123 | 20 | 10/28/2021 1:19:31 PM | 39 | 20 | ||||||||||||||||||||||
| 1803 | 2/23/2021 8:13:09 AM | 3/2/2022 8:22:38 AM | WATER QUERY | 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. | 4 | 3 | 1705 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T08:13:16.202Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T08:20:57.776Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-25T09:24:21.610Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-25T09:25:02.372Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T10:28:41.935Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:18:59.621Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1802 | 2/23/2021 7:56:34 AM | 3/2/2022 8:22:38 AM | WATER METER READING QUERY | 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. | 4 | 3 | 1704 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T07:56:41.769Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:18:38.095Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1801 | 2/23/2021 7:24:49 AM | 12/6/2021 12:30:37 PM | WATER QUERY | WATER QUERY<div>6 months policy journal done for 20191220 period</div><br/><b>Journal Number</b>: [439908]<br/><b>Journal Amount</b>: [-R832.69] | 27 | 3 | 1703 | 12 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T07:24:55.855Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T07:30:03.961Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:18:05.932Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-06T12:28:52.820Z"}] | 1 | 101 | 3 | 12/6/2021 12:30:37 PM | 12 | 3 | ||||||||||||||||||||||
| 1800 | 2/22/2021 1:07:09 PM | 3/2/2022 8:22:38 AM | WATER QUERY | 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. | 4 | 3 | 1702 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T13:07:16.551Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:17:29.270Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1798 | 2/22/2021 1:01:43 PM | 3/2/2022 8:22:38 AM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY<div>debt written off</div> | 27 | 3 | 1701 | 37 | 4 | 23 | 1 | 67 | 1142 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T13:01:50.749Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-17T12:44:34.915Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:16:59.049Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T09:42:53.443Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-12-17T08:55:36.677Z"}] | 1 | 101 | 6 | 3/2/2022 8:22:38 AM | 37 | 6 | |||||||||||||||||||||
| 1797 | 2/22/2021 12:57:22 PM | 3/2/2022 8:22:38 AM | WATER QUERY | 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. | 4 | 3 | 1700 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T12:57:30.212Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:16:36.846Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1796 | 2/22/2021 12:33:25 PM | 3/2/2022 8:22:38 AM | LATE TERMINATION | LATE TERMINATION | 27 | 3 | 1699 | 37 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T12:33:33.053Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:59:50.839Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:11:03.664Z"}] | 77 | 107 | 3/2/2022 8:22:38 AM | 37 | 173 | |||||||||||||||||||||||
| 1795 | 2/22/2021 12:27:44 PM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY | 27 | 3 | 1698 | 37 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T12:27:51.969Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T10:46:53.096Z"}] | 1 | 111 | 13 | 3/2/2022 8:22:38 AM | 37 | 13 | ||||||||||||||||||||||
| 1793 | 2/22/2021 11:35:24 AM | 2/2/2022 12:28:44 PM | this is an open road | <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 | 72 | 2 | 23 | 1 | 48 | 752 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-22T11:35:27.073Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:16:13.709Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:02:17.555Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 1792 | 2/22/2021 11:22:25 AM | 2/2/2022 12:28:44 PM | High water consumption | <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 | 72 | 2 | 23 | 1 | 67 | 751 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-22T11:22:27.530Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:15:54.307Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:03:17.002Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 1791 | 2/22/2021 11:04:25 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings updated | 27 | 3 | 1697 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-22T11:04:27.087Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:25:46.638Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1790 | 2/22/2021 10:58:56 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1696 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-22T10:58:58.925Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:48:03.050Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:48:25.919Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1789 | 2/22/2021 10:57:42 AM | 3/2/2022 8:22:38 AM | WATER QUERY | 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. | 4 | 3 | 1695 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-22T10:57:49.921Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T08:37:21.557Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:15:28.417Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1788 | 2/22/2021 10:54:39 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1694 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-22T10:54:41.234Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:36:30.472Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:37:10.909Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 12 |