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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1836 | 2/24/2021 8:23:44 AM | 3/28/2022 6:33:19 AM | water | six months policy applied<br/><b>Journal Number</b>: [366389]<br/><b>Journal Amount</b>: [R826.48] | 27 | 3 | 1731 | 3 | 2 | 23 | 1 | 50 | 1338 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:20:33.178Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-06T11:00:42.965Z"}] | 1 | 50 | 3/28/2022 6:33:19 AM | 3 | 3 | ||||||||||||||||||||||
| 1835 | 2/24/2021 8:21:01 AM | 10/20/2021 1:10:03 PM | water | six months policy applied<br><b>Journal Number</b>: [1108111]<div><br></div><div>Resolved 2020/10</div> | 27 | 3 | 1730 | 12 | 2 | 23 | 1 | 50 | 2009 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:17:46.377Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-12T10:37:48.877Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-12T09:43:03.054Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-12T09:44:17.182Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-20T13:10:00.433Z"}] | 1 | 50 | 10/20/2021 1:10:03 PM | 12 | 230 | ||||||||||||||||||||||
| 1834 | 2/24/2021 8:18:59 AM | 3/2/2022 8:22:38 AM | ELECTRICITY QUERY | account is in order<div>check readings for water requested </div> | 27 | 3 | 1729 | 37 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T08:15:36.436Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:20:18.924Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:21:37.631Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:22:56.622Z"}] | 77 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1833 | 2/24/2021 8:16:56 AM | 10/28/2021 1:23:35 PM | water | six months policy applied<br/><b>Journal Number</b>: [bj71826744] | 24 | 3 | 1728 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:13:34.482Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-13T10:46:05.345Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T11:42:42.812Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:23:24.242Z"}] | 1 | 101 | 20 | 20 | |||||||||||||||||||||||||
| 1831 | 2/24/2021 8:14:08 AM | 4/12/2022 9:47:18 AM | water | six months policy applied<br><br><br/><b>Journal Number</b>: [826777] | 24 | 3 | 1727 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:10:45.784Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T10:19:55.219Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T09:56:29.948Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:23:12.869Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:00:57.342Z"}] | 1 | 101 | 14 | 14 | |||||||||||||||||||||||||
| 1830 | 2/24/2021 8:11:19 AM | 3/28/2022 6:35:04 AM | six months pol | six months policy applied<br/><b>Journal Number</b>: [366367] | 27 | 3 | 1726 | 5 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T08:07:56.993Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-13T10:27:11.093Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:22:51.428Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T09:12:17.260Z"}] | 1 | 101 | 11 | 3/28/2022 6:35:04 AM | 5 | 11 | ||||||||||||||||||||||
| 1829 | 2/24/2021 8:10:39 AM | 4/11/2022 8:39:51 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 | 1725 | 22 | 3 | 23 | 77 | 96 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T08:10:42.306Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:22:31.751Z"},{"op":"R","uid":"232","un":"philiswan","dt":"2022-04-11T08:36:01.567Z"}] | 9 | 123 | 20 | 4/11/2022 8:39:51 AM | 22 | 20 | ||||||||||||||||||||||
| 1828 | 2/24/2021 8:02:04 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 | 1724 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-24T08:02:06.482Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:22:06.849Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1827 | 2/24/2021 7:59:52 AM | 3/2/2022 8:22:38 AM | WATER READING QUERY | readings up-to-date | 27 | 3 | 1723 | 37 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T07:56:30.132Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:16:19.278Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:16:38.664Z"}] | 77 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1824 | 2/23/2021 1:10:23 PM | 2/23/2021 1:10:25 PM | 2 | 1722 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-23T13:07:01.781Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1823 | 2/23/2021 1:06:01 PM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY<div><br></div><div>- account in order</div> | 27 | 3 | 1721 | 37 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T13:06:07.486Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T10:45:24.770Z"}] | 1 | 101 | 13 | 3/2/2022 8:22:38 AM | 37 | 13 | ||||||||||||||||||||||
| 1822 | 2/23/2021 12:58:18 PM | 3/2/2022 8:22:38 AM | WATER QUIERY | WATER QUERY<div>Journal Done</div> | 27 | 3 | 1720 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T12:58:24.506Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:05:51.463Z"}] | 1 | 101 | 17 | 3/2/2022 8:22:38 AM | 37 | 17 | ||||||||||||||||||||||
| 1820 | 2/23/2021 12:31:00 PM | 10/13/2021 9:17:14 AM | Water query - Overcharge | Water query - Overcharge<div>2021/05/11</div> | 27 | 3 | 1719 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-23T12:27:38.506Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:14:08.414Z"}] | 1 | 96 | 17 | 10/13/2021 9:17:14 AM | 33 | 17 | ||||||||||||||||||||||
| 1819 | 2/23/2021 10:45:05 AM | 2/23/2021 10:45:07 AM | 2 | 1718 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T10:45:11.899Z"}] | 37 | |||||||||||||||||||||||||||||||||||
| 1818 | 2/23/2021 10:38:32 AM | 4/12/2022 9:47:18 AM | WATER QUERY WITH SIX MONTHS POLICY | WATER QUERY WITH SIX MONTHS POLICY<br/><b>Journal Number</b>: [121171] | 27 | 3 | 1717 | 10 | 2 | 23 | 1 | 67 | 1595 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T10:38:39.918Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-04-28T07:43:51.173Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-09-02T07:05:27.382Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:28:35.914Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T08:54:58.799Z"}] | 1 | 101 | 11 | 4/12/2022 9:47:18 AM | 10 | 11 | |||||||||||||||||||||
| 1817 | 2/23/2021 10:30:40 AM | 3/2/2022 8:22:38 AM | WATER LEAK | no readings on meter, sent for check reading | 27 | 3 | 1716 | 37 | 2 | 23 | 77 | 100 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T10:30:47.090Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:21:44.532Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-19T06:41:17.359Z"}] | 1 | 96 | 17 | 3/2/2022 8:22:38 AM | 37 | 17 | ||||||||||||||||||||||
| 1815 | 2/23/2021 9:39:59 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY<div><br></div><div>interims more than water charge</div> | 27 | 3 | 1715 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:40:06.080Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T10:31:32.890Z"}] | 1 | 101 | 4 | 3/2/2022 8:22:38 AM | 37 | 4 | ||||||||||||||||||||||
| 1813 | 2/23/2021 9:39:15 AM | 4/12/2022 9:39:10 AM | previous incorrect meter reading | <br><b>Meter Reading Date:</b> []<br><b>Meter Reading:</b> [91]<div>high water consumption in October 2020. Current reading submitted by consumer is 919.</div><div>six months policy applied </div><br/><b>Journal Number</b>: [566592] | 24 | 3 | 1714 | 4 | 23 | 77 | 44 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-02-23T09:39:22.163Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-06-21T10:35:59.340Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-24T07:51:12.324Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:21:28.297Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:00:12.584Z"}] | 1 | 101 | 12 | 12 | |||||||||||||||||||||||||
| 1814 | 2/23/2021 9:35:39 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. | 27 | 3 | 1713 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:35:45.974Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:21:10.749Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:23:51.713Z"}] | 9 | 123 | 11 | 3/2/2022 8:22:38 AM | 37 | 11 | ||||||||||||||||||||||
| 1812 | 2/23/2021 9:30:36 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 | 1712 | 37 | 2 | 23 | 1 | 67 | 765 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-23T09:30:42.994Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:20:50.324Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 |