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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1861 | 2/24/2021 12:57:45 PM | 2/2/2022 12:28:44 PM | Consolidate tenant to owner | <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 | 77 | 76 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-24T12:54:23.283Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:26:33.896Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:58:02.639Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 1860 | 2/24/2021 12:47:28 PM | 3/2/2022 8:22:38 AM | WATER QUERY | readings up-to-date | 27 | 3 | 1750 | 37 | 3 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T12:44:06.142Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:39:40.171Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:40:06.320Z"}] | 77 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1858 | 2/24/2021 12:38:31 PM | 2/25/2022 9:01:52 AM | INCORRECT READINGS | readings up-to-date | 27 | 3 | 1749 | 29 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T12:38:33.200Z"},{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T12:38:41.298Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:39:45.307Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:43:01.417Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:43:15.606Z"}] | 77 | 44 | 2/25/2022 9:01:52 AM | 29 | 12 | |||||||||||||||||||||||
| 1859 | 2/24/2021 12:37:17 PM | 3/2/2022 8:22:38 AM | LATE TERMINATION | LATE TERMINATION | 27 | 3 | 1748 | 37 | 2 | 23 | 6 | 59 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T12:33:54.736Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-05T18:52:55.993Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-05T18:55:33.879Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:49:50.132Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:14:37.893Z"}] | 6 | 59 | 3/2/2022 8:22:38 AM | 37 | 173 | |||||||||||||||||||||||
| 1857 | 2/24/2021 12:29:42 PM | 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 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-24T12:26:20.454Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:26:04.373Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:59:16.163Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 1854 | 2/24/2021 12:26:57 PM | 5/30/2022 1:49:24 PM | water query/leak | water query/leak plumbers letter submitted<div>customer to re submit leak letter</div><div>leak credit adjustment dine 202105-202110 av 15kl</div><br/><b>Journal Number</b>: [994375]<br/><b>Journal Amount</b>: [-R29,470.19] | 27 | 3 | 1747 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T12:27:00.038Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-09-17T07:57:42.789Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:25:34.290Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-11-03T11:04:12.324Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T12:42:39.316Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-19T07:49:11.144Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-21T07:44:43.564Z"}] | 1 | 96 | 6 | 5/30/2022 1:49:17 PM | 3 | 3 | ||||||||||||||||||||||
| 1853 | 2/24/2021 12:16:31 PM | 7/21/2021 9:36:02 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 13 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T12:13:09.056Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:12:43.240Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:36:01.770Z"}] | 1 | 44 | 7/21/2021 9:36:02 AM | 13 | 14 | ||||||||||||||||||||||||
| 1851 | 2/24/2021 12:02:30 PM | 2/24/2022 11:08:12 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 | 1744 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T12:02:32.731Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:25:06.949Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1852 | 2/24/2021 12:00:59 PM | 3/2/2022 8:22:38 AM | REFUSE QUERY | REFUSE QUERY<div><br></div><div><b><u>QRC RESPONSE:</u> </b>Services amended and journal authorised in 202011. Query resolved<br></div> | 27 | 3 | 1743 | 37 | 2 | 23 | 77 | 105 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T11:57:36.807Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:04:25.748Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:04:36.314Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:04:39.269Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:04:39.570Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:04:42.687Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:05:40.375Z"}] | 77 | 105 | 3/2/2022 8:22:38 AM | 37 | 8 | |||||||||||||||||||||||
| 1849 | 2/24/2021 11:52:09 AM | 2/24/2022 11:08:12 AM | leak plumbers letter | leak plumbers letter submitted<div>Journal Done</div> | 27 | 3 | 1742 | 22 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T11:52:11.411Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T06:45:22.396Z"}] | 1 | 96 | 17 | 2/24/2022 11:08:12 AM | 22 | 17 | ||||||||||||||||||||||
| 1848 | 2/24/2021 11:47:55 AM | 2/24/2022 11:08:12 AM | incorrect readings | <span style="background-color: rgb(255, 255, 255);">readings updated</span> | 27 | 3 | 1741 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T11:47:57.477Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:30:03.219Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1847 | 2/24/2021 10:52:10 AM | 2/24/2022 11:08:12 AM | INCORRECT READINGS | <span style="background-color: rgb(255, 255, 255);">readings updated</span> | 27 | 3 | 1740 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T10:52:12.420Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:32:28.818Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1844 | 2/24/2021 10:23:54 AM | 3/28/2022 6:33:19 AM | leak | leak <div><br></div><div>Closed duplicate query. Active ref #3482</div> | 27 | 3 | 1739 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T10:23:56.690Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-22T09:53:56.290Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 1845 | 2/24/2021 10:23:21 AM | 3/2/2022 8:22:38 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="40" style="height:30.0pt"> <td height="40" class="xl63" width="547" style="height:30.0pt;width:410pt">Finalised in January 2019, a value was reduced from R 5 3000 000 to R 5 115 000 and rates were adjusted from August 2019 to Dec 2020.</td></tr></tbody></table></div> | 27 | 3 | 1738 | 37 | 2 | 23 | 77 | 64 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T10:19:58.957Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:24:40.293Z"}] | 77 | 64 | 3/2/2022 8:22:38 AM | 37 | 3 | |||||||||||||||||||||||
| 1843 | 2/24/2021 10:18:39 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1737 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T10:18:41.643Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:31:19.529Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:31:46.053Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-19T09:51:27.339Z"}] | 77 | 44 | 2/24/2022 11:08:12 AM | 22 | 18 | |||||||||||||||||||||||
| 1842 | 2/24/2021 10:13:37 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 | 1736 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T10:10:15.389Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T10:13:25.752Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T10:15:47.059Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:24:38.185Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1841 | 2/24/2021 10:03:59 AM | 3/2/2022 8:22:38 AM | LATE TERMINATION | LATE TERMINATION | 27 | 3 | 1735 | 37 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T10:00:37.405Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:48:46.732Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:13:14.994Z"}] | 6 | 107 | 3/2/2022 8:22:38 AM | 37 | 173 | |||||||||||||||||||||||
| 1840 | 2/24/2021 9:57:25 AM | 2/24/2022 11:08:12 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 | 1734 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T09:57:27.807Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:24:18.867Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1838 | 2/24/2021 8:33:15 AM | 3/28/2022 6:35:04 AM | water | six months policy applied<br><b>Journal Number</b>: [366382]<div><br></div><div>Property sold 2020/05/29. Referred to Coastal Billing to process final reading as per registration date</div> | 24 | 3 | 1733 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:29:53.243Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T10:21:27.669Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-12T09:32:06.735Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:23:53.204Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T10:49:03.137Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-21T08:25:56.394Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-16T08:29:58.927Z"}] | 1 | 101 | 20 | 20 | |||||||||||||||||||||||||
| 1837 | 2/24/2021 8:26:14 AM | 3/28/2022 6:33:19 AM | water | six months policy applied<br/><b>Journal Number</b>: [366426]<br/><b>Journal Amount</b>: [R19700.80] | 27 | 3 | 1732 | 3 | 2 | 23 | 1 | 50 | 1339 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:22:52.414Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-06T11:01:13.390Z"}] | 1 | 50 | 3/28/2022 6:33:19 AM | 3 | 3 |