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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1908 | 2/26/2021 9:47:26 AM | 8/3/2022 9:20:00 AM | WATER QUERY | WATER QUERY<div>Consumtion still high to contact consumer </div><br/><b>Journal Number</b>: [892071] | 24 | 3 | 1782 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T09:47:28.765Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T10:11:24.398Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:16:48.600Z"}] | 1 | 96 | 12 | 6 | |||||||||||||||||||||||||
| 1906 | 2/26/2021 9:29:25 AM | 8/15/2021 10:47:39 AM | log query | readings up-to-date | 27 | 3 | 1781 | 39 | 2 | 23 | 1 | 44 | 819 | [{"op":"R","uid":"39","un":"tembekas","dt":"2021-02-26T09:29:27.482Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:47:08.223Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:47:32.639Z"}] | 1 | 44 | 8/15/2021 10:47:39 AM | 39 | 12 | ||||||||||||||||||||||
| 1905 | 2/26/2021 9:20:31 AM | 2/26/2021 9:20:42 AM | 2 | 1780 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-26T09:20:37.136Z"}] | 33 | |||||||||||||||||||||||||||||||||||
| 1902 | 2/26/2021 8:38:46 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 | 1779 | 37 | 2 | 23 | 1 | 67 | 818 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T08:39:13.959Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T08:41:02.711Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T10:03:46.864Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:16:22.065Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:45:59.799Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | |||||||||||||||||||||
| 1901 | 2/26/2021 8:28:42 AM | 2/2/2022 12:28:44 PM | High water query | <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-26T08:29:25.888Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:53:40.012Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 1900 | 2/26/2021 7:46:00 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 | 1778 | 37 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T07:46:02.565Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:15:52.294Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1899 | 2/26/2021 7:26:36 AM | 2/26/2021 7:26:38 AM | 2 | 1777 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T07:26:38.442Z"}] | 37 | |||||||||||||||||||||||||||||||||||
| 1898 | 2/26/2021 7:18:17 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 | 1776 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T07:18:28.615Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:15:31.417Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-02T12:10:13.333Z"}] | 9 | 123 | 11 | 3/2/2022 8:22:38 AM | 37 | 11 | ||||||||||||||||||||||
| 1897 | 2/26/2021 7:11:11 AM | 2/23/2023 12:05:27 PM | WATER QUERY | six months policy applied.<br><b>Journal Number</b>: [439945]<div><br></div><div>Debt Write Off</div> | 27 | 3 | 1775 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T07:11:13.793Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:15:01.036Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:35:30.666Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-12-03T09:54:47.767Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-12-03T09:55:18.773Z"}] | 1 | 101 | 12 | 2/23/2023 12:05:27 PM | 17 | 17 | ||||||||||||||||||||||
| 1896 | 2/26/2021 7:03:30 AM | 3/2/2022 8:22:38 AM | RATES AND FIRE LEVY QUERY | RATES AND FIRE LEVY 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="20" style="height:15.0pt"> <td height="20" class="xl65" width="547" style="height:15.0pt;width:410pt">No records for rezoning, Town Planning has confirmed </td></tr></tbody></table></div> | 27 | 3 | 1774 | 37 | 2 | 23 | 77 | 64 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T07:03:33.493Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:27:34.712Z"}] | 77 | 64 | 3/2/2022 8:22:38 AM | 37 | 3 | |||||||||||||||||||||||
| 1895 | 2/26/2021 6:54:03 AM | 7/25/2022 8:25:13 AM | LATE TERMINATION | Account Terminated duplicate query 20476 | 27 | 3 | 1773 | 132 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T06:54:05.243Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:14:37.506Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:10:15.055Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T11:04:42.463Z"}] | 6 | 122 | 20 | 7/25/2022 8:25:13 AM | 12 | 12 | ||||||||||||||||||||||
| 1894 | 2/26/2021 6:16:10 AM | 3/2/2022 9:17:59 AM | 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 | 1772 | 36 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-26T06:16:12.625Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:13:58.224Z"}] | 9 | 123 | 20 | 3/2/2022 9:17:59 AM | 36 | 20 | ||||||||||||||||||||||
| 1893 | 2/26/2021 6:12:25 AM | 2/26/2021 6:12:28 AM | 2 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-26T06:12:28.522Z"}] | 36 | ||||||||||||||||||||||||||||||||||||
| 1892 | 2/26/2021 6:10:08 AM | 2/26/2021 6:10:11 AM | 1 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-26T06:10:11.422Z"}] | 36 | ||||||||||||||||||||||||||||||||||||
| 1890 | 2/25/2021 1:06:58 PM | 2/24/2022 10:34:50 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 | 1771 | 26 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-25T13:07:00.513Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:13:37.274Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T06:55:49.260Z"}] | 9 | 123 | 11 | 2/24/2022 10:34:50 AM | 26 | 11 | ||||||||||||||||||||||
| 1889 | 2/25/2021 1:02:53 PM | 2/24/2022 10:34:50 AM | water query | water query<div><br></div><div>6months adjustment 2018/11</div> | 27 | 3 | 1770 | 26 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-25T13:02:55.351Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-25T13:03:03.581Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-24T10:41:46.815Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:13:23.590Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-14T06:53:21.469Z"}] | 1 | 96 | 11 | 2/24/2022 10:34:50 AM | 26 | 11 | ||||||||||||||||||||||
| 1887 | 2/25/2021 12:18:16 PM | 3/28/2022 6:33:19 AM | water | water leak credit 03/2019-07/2020 ave31<br><b>Journal Number</b>: [367061]<div>Journal released, Query Resolved</div> | 27 | 3 | 1769 | 3 | 2 | 23 | 1 | 50 | 1196 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-25T12:18:32.115Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-23T10:36:03.233Z"}] | 1 | 50 | 3/28/2022 6:33:19 AM | 3 | 3 | ||||||||||||||||||||||
| 1886 | 2/25/2021 11:36:03 AM | 2/2/2022 12:28:44 PM | Previous owner | 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 | 72 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-25T11:36:05.244Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:12:56.702Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | |||||||||||||||||||||||
| 1885 | 2/25/2021 11:29:08 AM | 2/2/2022 12:28:44 PM | Consolidate debt to indigent account | 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 | 72 | 2 | 23 | 77 | 76 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-25T11:29:10.159Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-21T07:37:16.646Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:12:29.781Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | |||||||||||||||||||||||
| 1884 | 2/25/2021 11:25:26 AM | 2/2/2022 12:28:44 PM | high water and electricity charges | 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 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-25T11:25:29.341Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:12:01.862Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 |