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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3328 | 4/16/2021 8:20:14 AM | 5/17/2022 8:51:08 AM | Water query - Overcharge | Consumer says actual reading that was sent is far less than the interim charge that he got charged, consumer is seeking for credit due to him | 27 | 3 | 2858 | 20 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-04-16T08:16:14.904Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T10:27:45.490Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:05:14.604Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T10:16:30.065Z"}] | 1 | 101 | 10 | 5/17/2022 8:51:08 AM | 20 | 10 | ||||||||||||||||||||||
| 3327 | 4/16/2021 7:55:27 AM | 5/19/2022 7:53:10 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 2857 | 18 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-16T07:51:26.272Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T11:41:56.127Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:04:21.805Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2022-04-07T08:36:23.385Z"}] | 9 | 123 | 14 | 5/19/2022 7:53:10 AM | 18 | 14 | ||||||||||||||||||||||
| 3326 | 4/16/2021 7:52:06 AM | 11/21/2021 9:04:53 AM | Leak plumbers letter submitted | Leak plumbers letter submitted<div><br></div><div>Query resolved on ref #9059. Duplicate query closed</div> | 27 | 3 | 2856 | 14 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-16T07:48:05.304Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T08:55:35.856Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T08:56:02.124Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T08:03:46.679Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-21T09:03:02.239Z"}] | 1 | 96 | 3 | 11/21/2021 9:04:53 AM | 14 | 3 | ||||||||||||||||||||||
| 3325 | 4/16/2021 7:41:59 AM | 11/2/2021 12:24:08 PM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 2855 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-16T07:37:58.543Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:03:34.687Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-02T12:24:08.785Z"}] | 9 | 123 | 14 | 11/2/2021 12:24:08 PM | 14 | 14 | ||||||||||||||||||||||
| 3324 | 4/16/2021 7:31:56 AM | 11/2/2021 10:03:03 AM | WATER QUERY | WATER QUERY | 4 | 3 | 2854 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-16T07:27:55.387Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T11:06:50.420Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:03:04.457Z"}] | 1 | 101 | 13 | 11/2/2021 10:03:03 AM | 14 | 13 | ||||||||||||||||||||||
| 3323 | 4/16/2021 7:22:52 AM | 3/22/2022 9:02:45 AM | leak consumer submitted a plumbers letter | leak plumbers letter submitted<br><b>Journal Number</b>: [910134]<div><br></div><div><b>RESPONSE QRC</b>: Leak CR AV-7 201911-202008,Journal {910134}Authorized</div> | 27 | 3 | 2853 | 74 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-16T07:18:52.019Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:02:23.774Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T12:28:51.156Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2022-03-22T09:02:45.740Z"}] | 1 | 96 | 230 | 3/22/2022 9:02:45 AM | 172 | 230 | ||||||||||||||||||||||
| 3322 | 4/16/2021 7:18:52 AM | 5/19/2022 7:53:10 AM | WATER | WATER QUERY<div><br></div><div>JOURNAL PROCESSED </div> | 27 | 3 | 2852 | 18 | 2 | 23 | 1 | 67 | 1466 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-16T07:14:57.423Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-04-16T07:17:26.277Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T11:38:27.509Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:01:52.132Z"}] | 1 | 101 | 13 | 5/19/2022 7:53:10 AM | 18 | 13 | |||||||||||||||||||||
| 940 | 4/15/2021 1:36:42 PM | 4/15/2021 1:36:43 PM | 1 | ||||||||||||||||||||||||||||||||||||||
| 3307 | 4/15/2021 1:19:23 PM | 4/15/2021 1:22:44 PM | 2 | [{"op":"R","uid":"187","un":"xolanim","dt":"2021-04-15T13:15:22.201Z"},{"op":"R","uid":"187","un":"xolanim","dt":"2021-04-15T13:18:22.939Z"},{"op":"R","uid":"187","un":"xolanim","dt":"2021-04-15T13:18:39.875Z"}] | 187 | ||||||||||||||||||||||||||||||||||||
| 3319 | 4/15/2021 12:54:19 PM | 3/28/2022 6:33:19 AM | 6 months policy journal done 20200628 | 6 months policy journal done 20200628<br/><b>Journal Number</b>: [251785]<br/><b>Journal Amount</b>: [R11765.27] | 27 | 3 | 2851 | 3 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-04-15T12:54:21.549Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-19T06:28:06.877Z"}] | 1 | 95 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 3318 | 4/15/2021 12:20:14 PM | 11/20/2021 11:34:11 AM | water query | WATER QUERY 6 MONTH POLICY<div><br></div><div>- actual charge less than interim reversal.</div> | 27 | 3 | 2850 | 14 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T12:16:14.849Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T12:17:21.561Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-07-22T12:35:35.381Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:01:09.687Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:28:56.412Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:55:14.786Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-20T11:34:12.221Z"}] | 1 | 101 | 13 | 11/20/2021 11:34:11 AM | 14 | 13 | ||||||||||||||||||||||
| 3317 | 4/15/2021 11:37:19 AM | 11/2/2021 10:00:47 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 2849 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T11:33:20.061Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T10:00:21.320Z"}] | 9 | 123 | 14 | 11/2/2021 10:00:47 AM | 14 | 14 | ||||||||||||||||||||||
| 3316 | 4/15/2021 11:26:53 AM | 2/2/2022 12:28:44 PM | High water consumption | kindly investigate high water charges raised on this account.<table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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-04-15T11:22:53.685Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T09:59:27.894Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 3315 | 4/15/2021 10:47:59 AM | 11/2/2021 9:58:37 AM | water query | water query no readings for more than 6 month | 27 | 3 | 2848 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T10:43:59.444Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T10:01:32.771Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T09:58:37.435Z"}] | 1 | 101 | 13 | 11/2/2021 9:58:37 AM | 14 | 13 | ||||||||||||||||||||||
| 3314 | 4/15/2021 9:49:44 AM | 11/11/2021 12:52:50 PM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 2847 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T09:45:44.228Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T09:45:53.682Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T09:57:44.154Z"},{"op":"R","uid":"187","un":"xolanim","dt":"2021-11-11T12:52:50.639Z"}] | 9 | 123 | 14 | 11/11/2021 12:52:50 PM | 14 | 14 | ||||||||||||||||||||||
| 3309 | 4/15/2021 9:19:17 AM | 7/21/2021 12:11:13 PM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2846 | 132 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-04-15T09:19:19.396Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T13:01:19.779Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T12:11:24.676Z"}] | 1 | 44 | 7/21/2021 12:11:13 PM | 230 | 14 | |||||||||||||||||||||||
| 3307 | 4/15/2021 9:16:27 AM | 4/15/2021 9:16:29 AM | 1 | [{"op":"R","uid":"187","un":"xolanim","dt":"2021-04-15T09:12:24.135Z"}] | 187 | ||||||||||||||||||||||||||||||||||||
| 3310 | 4/15/2021 9:16:17 AM | 3/28/2022 7:08:29 AM | 6 MONTHS POLICY JOURNAL 20200425 DONE | 6 MONTHS POLICY JOURNAL 20200425 DONE<br/><b>Journal Number</b>: [251282]<br/><b>Journal Amount</b>: [-R1205.21] | 27 | 3 | 2845 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-04-15T09:16:19.153Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:41:31.245Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 6 | 3 | |||||||||||||||||||||||
| 3308 | 4/15/2021 9:13:27 AM | 3/28/2022 7:10:22 AM | SIX MONTHS POLICY | JOURNAL PROCESSED<br/><b>Journal Number</b>: [undefined] | 27 | 3 | 2843 | 11 | 4 | 23 | 1 | 67 | 1460 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-04-15T09:13:29.028Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-13T10:57:17.412Z"}] | 1 | 67 | 3/28/2022 7:10:22 AM | 11 | 12 | ||||||||||||||||||||||
| 3306 | 4/15/2021 8:59:47 AM | 11/2/2021 9:57:05 AM | water query | high water consumption | 27 | 3 | 2842 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-15T08:55:47.590Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-31T08:58:05.919Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T09:57:06.177Z"}] | 1 | 101 | 13 | 11/2/2021 9:57:05 AM | 14 | 13 |