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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1545 | 2/12/2021 10:11:52 AM | 2/24/2022 11:08:12 AM | water query | latest reading captured 03/2021,current readings requested. | 27 | 3 | 1508 | 22 | 2 | 23 | 77 | 48 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T10:12:13.161Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:25:30.571Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:26:12.380Z"}] | 77 | 48 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1544 | 2/12/2021 10:06:29 AM | 2/24/2022 11:08:12 AM | water query | water query<div>account closed </div> | 27 | 3 | 1507 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T10:06:50.801Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-23T08:28:32.769Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:49:41.007Z"}] | 1 | 101 | 6 | 2/24/2022 11:08:12 AM | 22 | 6 | ||||||||||||||||||||||
| 1542 | 2/12/2021 10:02:23 AM | 2/2/2022 1:21:32 PM | Water | There is a water pipe leak<div><br></div><div>RESPONSE: AWAITING LEAK LETTER</div> | 27 | 3 | 1506 | 58 | 4 | 23 | 1 | 100 | [{"op":"R","uid":"59","un":"lulamad","dt":"2021-02-12T09:59:08.018Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:47:53.003Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:34:04.851Z"}] | 1 | 96 | 15 | 2/2/2022 1:21:32 PM | 59 | 15 | ||||||||||||||||||||||
| 1541 | 2/12/2021 9:58:13 AM | 3/28/2022 6:33:19 AM | water query | water query - DUPLICATE QUERY DELETED. Correct ref #3905 | 27 | 3 | 1505 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:58:34.541Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-22T08:25:59.723Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 1538 | 2/12/2021 9:55:27 AM | 10/28/2021 7:47:01 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 | 1504 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-12T09:55:48.918Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:46:47.747Z"}] | 9 | 123 | 20 | 10/28/2021 7:47:01 AM | 33 | 20 | ||||||||||||||||||||||
| 1540 | 2/12/2021 9:50:42 AM | 2/24/2022 11:08:12 AM | water query | water query | 27 | 3 | 1503 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:51:04.280Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T10:21:36.355Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T11:04:43.698Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T11:46:34.498Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:08:26.195Z"}] | 77 | 67 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1540 | 2/12/2021 9:50:32 AM | 7/30/2021 11:04:32 AM | water query | no query details | 4 | 2 | 1503 | 77 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:50:53.769Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T11:02:46.342Z"}] | 77 | 7/30/2021 11:04:32 AM | 20 | |||||||||||||||||||||||||||||
| 1539 | 2/12/2021 9:48:01 AM | 10/17/2021 11:30:45 AM | water query six months policy | water query six months policy<div>6 months policy 20200927 journal done </div><br/><b>Journal Number</b>: [071816]<br/><b>Journal Amount</b>: [-R3,697.92] | 27 | 3 | 1502 | 75 | 4 | 23 | 1 | 67 | 573 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-12T09:48:28.179Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T10:21:16.153Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-28T09:15:53.656Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-28T09:42:44.902Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-17T11:29:49.026Z"}] | 1 | 101 | 3 | 10/17/2021 11:30:45 AM | 173 | 3 | |||||||||||||||||||||
| 1537 | 2/12/2021 9:17:03 AM | 2/2/2022 1:21:32 PM | transfere of services | Transfer of services from an old account to a new account <div>Regitration date 2020/11 billing Coastal region to terminate<br></div><div>old account terminated.</div> | 27 | 3 | 1501 | 58 | 4 | 23 | 6 | 107 | [{"op":"R","uid":"59","un":"lulamad","dt":"2021-02-12T09:13:48.458Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:38:04.871Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:00:48.572Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-24T07:08:08.573Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:46:11.236Z"}] | 6 | 122 | 20 | 2/2/2022 1:21:32 PM | 59 | 20 | ||||||||||||||||||||||
| 1536 | 2/12/2021 9:15:40 AM | 2/24/2022 11:08:12 AM | incorrect readings | incorrect readings<div>Journal Done</div> | 27 | 3 | 1500 | 22 | 4 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:16:32.693Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:54:55.689Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:32:53.754Z"}] | 1 | 111 | 17 | 2/24/2022 11:08:12 AM | 22 | 17 | ||||||||||||||||||||||
| 1535 | 2/12/2021 9:14:52 AM | 3/2/2022 8:22:38 AM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY | 30 | 3 | 1499 | 2 | 23 | 1 | 67 | 566 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-12T09:15:13.905Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T10:20:56.828Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:45:43.598Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:37:40.390Z"}] | 1 | 101 | 20 | 20 | ||||||||||||||||||||||||
| 1534 | 2/12/2021 9:07:03 AM | 10/16/2021 11:32:54 AM | 6 months policy on Electricity journal processed for 202104 period | 6 months policy on Electricity journal processed for 202104 period<br/><b>Journal Amount</b>: [15953.61]<br/><b>Journal Number</b>: [162552] | 27 | 3 | 1498 | 75 | 2 | 23 | 2 | 101 | 565 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:07:24.671Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-06-09T10:00:41.714Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-11T07:56:22.172Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-09-16T11:23:02.346Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-09-16T13:20:56.643Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-10-16T11:32:54.576Z"}] | 2 | 101 | 10/16/2021 11:32:54 AM | 173 | 214 | ||||||||||||||||||||||
| 1512 | 2/12/2021 9:06:08 AM | 9/7/2022 12:05:02 PM | Water query - six months policy | Water query - six months policy<br/><b>Journal Number</b>: [bj71826739]<br/><b>Journal Amount</b>: [-R3,071.59] | 27 | 3 | 1497 | 75 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-12T09:15:57.360Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T07:22:22.768Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:57:01.853Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:45:17.005Z"}] | 1 | 101 | 20 | 9/7/2022 12:04:58 PM | 136630 | 3 | 3 | |||||||||||||||||||||
| 1533 | 2/12/2021 9:02:59 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 | 1496 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T09:03:20.390Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:44:55.857Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1532 | 2/12/2021 8:57:23 AM | 3/19/2022 10:16:35 AM | incorrect readings of 2020 | reading updated | 27 | 3 | 1495 | 22 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T08:57:51.025Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:24:25.119Z"},{"op":"R","uid":"889","un":"rethabilel","dt":"2022-03-19T10:16:35.450Z"}] | 77 | 44 | 3/19/2022 10:16:35 AM | 22 | 889 | |||||||||||||||||||||||
| 1531 | 2/12/2021 8:51:09 AM | 8/15/2021 10:43:42 AM | log query | latest reading was taken 05/2021,current reading requested. | 27 | 3 | 1494 | 39 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"39","un":"tembekas","dt":"2021-02-12T08:51:10.929Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:42:30.862Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:43:39.402Z"}] | 77 | 44 | 8/15/2021 10:43:42 AM | 39 | 12 | |||||||||||||||||||||||
| 1529 | 2/12/2021 8:44:33 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1493 | 22 | 2 | 23 | 77 | 48 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T08:44:54.836Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T08:45:07.707Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:35:56.568Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:36:16.016Z"}] | 77 | 48 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1528 | 2/12/2021 8:39:37 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 | 1492 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T08:39:58.443Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:44:37.432Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1527 | 2/12/2021 8:34:22 AM | 2/24/2022 11:08:12 AM | billing of April & May 2020 | Debt written off.<div>readings up-to-date<br></div> | 27 | 3 | 1491 | 22 | 2 | 23 | 1 | 48 | 558 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-12T08:34:43.567Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:03:30.415Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:04:45.406Z"}] | 1 | 48 | 2/24/2022 11:08:12 AM | 22 | 12 | ||||||||||||||||||||||
| 1525 | 2/12/2021 8:10: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 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-12T08:07:11.830Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:44:17.565Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:31:45.210Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 |