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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 91 | 6/5/2020 11:41:10 AM | 3/2/2022 7:53:56 AM | Log Query | Journal Done | 27 | 3 | 106 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:06:27.926Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:34:01.569Z"}] | 1 | 50 | 17 | 3/2/2022 7:53:56 AM | 34 | 34 | 17 | |||||||||||||||||||
| 0 | 90 | 6/5/2020 11:24:31 AM | 3/2/2022 7:53:56 AM | Log Query | Journal Done | 27 | 3 | 104 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:26:10.180Z"}] | 3 | 115 | 17 | 3/2/2022 7:53:56 AM | 34 | 34 | 17 | |||||||||||||||||||
| 0 | 89 | 6/5/2020 6:41:19 AM | 2/14/2023 9:14:47 AM | WATER INTERIMS BILLED | METER WAS LAST READ AND PROCESSED IN AUGUST 2020.,KINDLY INVESTIGATE AND RESOLVE.<div><br></div><div>QRC Response - readings updated on system.</div> | 27 | 3 | 100 | 34 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-23T08:12:01.620Z"},{"op":"R","uid":"23","un":"bevins","dt":"2021-08-07T09:35:47.103Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:16:30.379Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:26:18.897Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:26:48.889Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:31:11.166Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:32:02.763Z"},{"op":"R","uid":"23","un":"bevins","dt":"2021-11-16T16:55:08.345Z"}] | 1 | 101 | 14 | 2/14/2023 9:14:46 AM | 13 | 34 | 13 | |||||||||||||||||||
| 0 | 88 | 6/5/2020 5:58:25 AM | 3/2/2022 7:53:56 AM | Log Query | journal done | 27 | 3 | 98 | 34 | 34 | 2 | 23 | 67 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:06:07.687Z"}] | 1 | 111 | 6 | 3/2/2022 7:53:56 AM | 34 | 34 | 6 | ||||||||||||||||||||
| 0 | 87 | 6/5/2020 5:35:29 AM | 3/2/2022 7:53:56 AM | Log Query | <span style="color: rgba(0, 0, 0, 0.87); font-size: 14px; letter-spacing: 0.13118px; background-color: rgb(255, 255, 255);">Meter Changed or Incorrect Meter Number</span><div><span style="color: rgba(0, 0, 0, 0.87); font-size: 14px; letter-spacing: 0.13118px; background-color: rgb(255, 255, 255);"><br></span></div><div><span style="color: rgba(0, 0, 0, 0.87); font-size: 14px; letter-spacing: 0.13118px; background-color: rgb(255, 255, 255);">w/off pay debit </span></div> | 27 | 3 | 94 | 34 | 34 | 3 | 23 | 67 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T06:43:50.786Z"}] | 1 | 112 | 4 | 3/2/2022 7:53:56 AM | 34 | 34 | 4 | ||||||||||||||||||||
| 0 | 86 | 6/4/2020 2:05:16 PM | 2/24/2022 10:34:50 AM | water query | <br/><b>Monitoring Reason</b>: [water query] | 10 | 2 | 91 | 26 | 26 | 77 | 77 | 2/24/2022 10:34:50 AM | 26 | 26 | ||||||||||||||||||||||||||
| 0 | 85 | 6/4/2020 1:03:44 PM | 2/24/2022 11:21:35 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 90 | 9 | 9 | 2 | 1 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:14:15.340Z"}] | 9 | 123 | 14 | 2/24/2022 11:21:35 AM | 9 | 9 | 14 | |||||||||||||||||||
| 0 | 41082 | 84 | 6/4/2020 11:28:38 AM | 2/25/2022 9:22:48 AM | Log Query | <span style="font-family: "Courier New", Helvetica, sans-serif; font-size: 11px; letter-spacing: 1px; white-space: pre;"> </span><table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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><span style="font-family: "Courier New", Helvetica, sans-serif; font-size: 11px; letter-spacing: 1px; white-space: pre;"> </span> | 4 | 3 | 89 | 41 | 41 | 2 | 1 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:08:24.949Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:09:49.628Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T08:11:14.668Z"}] | 9 | 123 | 14 | 2/25/2022 9:22:48 AM | 41 | 41 | 14 | ||||||||||||||||||
| 0 | 79 | 6/4/2020 9:36:41 AM | 3/28/2022 7:08:29 AM | Log Query | 6 MONTHS POLICY JOURNAL DONE <br/><b>Journal Number</b>: [439921] | 27 | 3 | 82 | 41 | 6 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:14:02.465Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:06:52.599Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T08:35:06.387Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T08:59:20.947Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-05T08:20:10.924Z"}] | 1 | 101 | 3 | 3/28/2022 7:08:29 AM | 6 | 41 | 3 | |||||||||||||||||||
| 0 | 83 | 6/3/2020 9:40:04 AM | 3/2/2022 7:53:56 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.5pt"> <td height="31" class="xl63" width="609" style="height:23.5pt;width:457pt">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 | 88 | 34 | 34 | 2 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-23T07:44:39.493Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-23T07:57:22.733Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:13:40.440Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-22T07:45:56.188Z"}] | 9 | 123 | 2 | 3/2/2022 7:53:56 AM | 34 | 34 | 2 | ||||||||||||||||||||
| 0 | 82 | 6/3/2020 5:26:54 AM | 3/2/2022 7:53:56 AM | Log Query | <span style="background-color: rgb(255, 255, 255);">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.</span><div style="background-color: rgb(255, 255, 255);">New query to be logged with full information of query.</div> | 4 | 3 | 85 | 34 | 34 | 2 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:10:38.192Z"}] | 9 | 123 | 2 | 3/2/2022 7:53:56 AM | 34 | 34 | 2 | ||||||||||||||||||||
| 0 | 39486 | 81 | 6/2/2020 10:56:04 AM | 3/2/2022 9:15:13 AM | Log Query | High water consumption<div>High interims were being billed, but were reversed on the June 2020 account.</div><div>The query has been resolved.</div> | 27 | 3 | 84 | 40 | 40 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:03:18.788Z"}] | 1 | 101 | 2 | 3/2/2022 9:15:13 AM | 40 | 40 | 2 | ||||||||||||||||||
| 0 | 80 | 6/2/2020 10:53:11 AM | 2/10/2023 12:29:14 PM | Log Query | CONSUMER QUERYING HIGH CONSUMPTION,KINDLY INVESTIGATE AND RESOLVE.<div><br></div><div><br></div><div>Response from QRC: Plumbers letter received.</div><div>Resolved Nov 2020 with a leak credit</div> | 27 | 3 | 83 | 39 | 17 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-22T09:14:31.751Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T06:15:00.192Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:02:12.741Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:16:15.163Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-17T06:54:42.962Z"}] | 1 | 96 | 2 | 2/10/2023 12:29:14 PM | 3 | 39 | 3 | |||||||||||||||||||
| 0 | 79 | 6/1/2020 10:45:27 AM | 3/28/2022 7:25:06 AM | water | six months policy to be applied | 27 | 3 | 82 | 17 | 17 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-01-19T12:40:24.798Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-01-19T12:40:53.403Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-01-19T12:41:24.399Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:23:26.106Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:13:54.273Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:07:59.039Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T08:35:38.017Z"}] | 1 | 95 | 3/28/2022 7:25:06 AM | 17 | 17 | 6 | ||||||||||||||||||||
| 0 | 38268 | 78 | 6/1/2020 9:04:57 AM | 3/2/2022 7:53:56 AM | Log Query | Query voided as query logged as "Log Query" with no other information, category or sub-category. New query to be logged with full information. | 27 | 3 | 81 | 34 | 34 | 2 | 23 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:01:36.152Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:14:37.046Z"}] | 9 | 123 | 6 | 3/2/2022 7:53:56 AM | 34 | 34 | 6 | |||||||||||||||||||
| 0 | 77 | 6/1/2020 6:15:00 AM | 3/2/2022 7:53:56 AM | Log Query | <span style="background-color: rgb(255, 255, 255);">Query voided as query logged as "Log Query" with no other information, category or sub-category. New query to be logged with full information.</span> | 27 | 3 | 80 | 34 | 34 | 2 | 23 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:00:35.780Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:15:47.969Z"}] | 9 | 123 | 6 | 3/2/2022 7:53:56 AM | 34 | 34 | 6 | ||||||||||||||||||||
| 0 | 76 | 6/1/2020 5:54:23 AM | 3/2/2022 7:53:56 AM | Log Query | Query voided as query logged as "Log Query" with no other information, category or sub-category. New query to be logged with full information.<div><br></div> | 4 | 3 | 78 | 34 | 34 | 3 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T13:57:09.449Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T13:58:12.582Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T14:00:11.579Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-23T10:34:56.294Z"},{"op":"R","uid":"23","un":"bevins","dt":"2022-02-27T11:12:20.895Z"}] | 9 | 123 | 2 | 3/2/2022 7:53:56 AM | 34 | 34 | 2 | ||||||||||||||||||||
| 0 | 75 | 5/30/2020 5:10:16 PM | 3/2/2022 7:53:56 AM | Log Query | 4 | 3 | 73 | 34 | 34 | 2 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T13:45:51.064Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-21T13:57:32.654Z"}] | 67 | 2 | 3/2/2022 7:53:56 AM | 34 | 34 | 2 | ||||||||||||||||||||||
| 0 | 74 | 5/29/2020 10:33:27 AM | 4/12/2022 9:39:10 AM | water leak | leak credit done from 2017.12 -2018.03<br/><b>Journal Number</b>: [532765] | 27 | 3 | 72 | 4 | 4 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:32:35.987Z"}] | 1 | 96 | 17 | 4/12/2022 9:39:10 AM | 4 | 4 | 17 | ||||||||||||||||||||
| 0 | 35939 | 73 | 5/28/2020 2:00:55 PM | 4/12/2022 9:43:30 AM | Six Months Pol | Journal Done | 27 | 3 | 71 | 34 | 7 | 2 | 23 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T08:20:52.947Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:14:01.938Z"}] | 1 | 101 | 17 | 4/12/2022 9:43:30 AM | 7 | 34 | 17 |