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 | 425 | 8/21/2020 9:33:15 AM | 3/28/2022 6:35:04 AM | Leak | Journal Done | 27 | 3 | 597 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:22:31.996Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:24:19.200Z"}] | 1 | 96 | 17 | 3/28/2022 6:35:04 AM | 5 | 5 | 17 | |||||||||||||||||||
| 0 | 424 | 8/21/2020 9:09:41 AM | 3/28/2022 6:35:04 AM | six months pol | Journal Done | 27 | 3 | 596 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:50:22.638Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:24:43.384Z"}] | 1 | 101 | 17 | 3/28/2022 6:35:04 AM | 5 | 5 | 17 | |||||||||||||||||||
| 0 | 423 | 8/21/2020 9:00:04 AM | 3/28/2022 6:35:04 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 | 595 | 5 | 5 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-12T08:40:41.554Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:05:29.766Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:06:35.659Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-12-14T09:10:31.438Z"}] | 9 | 123 | 14 | 3/28/2022 6:35:04 AM | 5 | 5 | 14 | |||||||||||||||||||
| 0 | 422 | 8/21/2020 8:13:05 AM | 3/28/2022 6:35:04 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 | 594 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T10:22:11.278Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:07:59.930Z"}] | 9 | 123 | 14 | 3/28/2022 6:35:04 AM | 5 | 5 | 14 | |||||||||||||||||||
| 0 | 421 | 8/20/2020 5:35:07 PM | 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.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 | 592 | 34 | 34 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:09:50.147Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:11:08.509Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T12:57:34.705Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 8/20/2020 12:35:51 PM | 4/12/2022 9:43:30 AM | 6 months policy | 6 months policy to be processed | 4 | 3 | 7 | 2 | 23 | 1 | 48 | 1 | 48 | 7 | ||||||||||||||||||||||||||||
| 0 | 419 | 8/20/2020 10:29:42 AM | 6/14/2022 6:42:06 AM | 6 months policy | 6 months policy to be processed<br><b>Journal Number</b>: [BJ71102960]<br/><b>Journal Amount</b>: [-R6,776.38] | 27 | 3 | 589 | 7 | 17 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-07T11:31:53.745Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T09:51:25.458Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:12:27.148Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:13:55.408Z"}] | 1 | 101 | 14 | 6/14/2022 6:42:01 AM | 3 | 7 | 3 | |||||||||||||||||||
| 0 | 418 | 8/20/2020 9:37:15 AM | 4/12/2022 9:43:30 AM | 6 months policy | 6 months policy to be applied<div>readings up-to-date<br></div> | 27 | 3 | 588 | 7 | 7 | 2 | 23 | 1 | 48 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:55:54.756Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:56:16.919Z"}] | 1 | 48 | 4/12/2022 9:43:30 AM | 7 | 7 | 12 | ||||||||||||||||||||
| 0 | 417 | 8/20/2020 9:35:58 AM | 2/18/2021 5:01:02 AM | 4 | 2 | 587 | 56 | 56 | 2/18/2021 5:01:02 AM | 57 | 57 | ||||||||||||||||||||||||||||||
| 0 | 416 | 8/20/2020 9:24:23 AM | 2/18/2021 4:43:13 AM | 4 | 2 | 586 | 57 | 57 | 2/18/2021 4:43:13 AM | 58 | 58 | ||||||||||||||||||||||||||||||
| 0 | 415 | 8/20/2020 9:09:00 AM | 2/2/2022 2:03:19 PM | 4 | 2 | 585 | 61 | 61 | 2/2/2022 2:03:19 PM | 62 | 62 | ||||||||||||||||||||||||||||||
| 0 | 414 | 8/20/2020 9:08:36 AM | 3/28/2022 6:35:04 AM | 30 | 3 | 584 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T09:15:03.078Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:58:04.487Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:52:14.404Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:53:44.433Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-18T10:10:27.795Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:38:00.979Z"}] | 1 | 67 | 5 | 214 | |||||||||||||||||||||||||
| 0 | 8/20/2020 8:13:29 AM | 2/18/2021 4:56:00 AM | 4 | 2 | 67 | 67 | 2/18/2021 4:56:00 AM | 68 | 68 | ||||||||||||||||||||||||||||||||
| 0 | 413 | 8/20/2020 6:45:05 AM | 3/28/2022 6:35:04 AM | water query | Journal Done<div><br></div><div>JOURNAL DONE 202103 JOURNAL NUMBER <span style="font-family: "Courier New", Helvetica, sans-serif; font-size: 11px; letter-spacing: 1px; white-space: pre;">471147</span> </div> | 27 | 3 | 583 | 5 | 5 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:57:02.196Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T07:08:18.054Z"}] | 1 | 96 | 13 | 3/28/2022 6:35:04 AM | 5 | 5 | 13 | |||||||||||||||||||
| 0 | 412 | 8/19/2020 4:16:59 PM | 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.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">query resolved refer to ref no 3962</td></tr></tbody></table> | 27 | 3 | 579 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:56:34.469Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:56:42.348Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2022-02-27T07:33:51.436Z"}] | 1 | 96 | 12 | 3/2/2022 7:53:56 AM | 34 | 34 | 12 | |||||||||||||||||||
| 0 | 411 | 8/19/2020 1:47:36 PM | 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.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> | 27 | 3 | 578 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:55:08.908Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:55:54.241Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T11:53:07.974Z"}] | 9 | 123 | 6 | 3/2/2022 7:53:56 AM | 34 | 34 | 6 | |||||||||||||||||||
| 0 | 410 | 8/19/2020 10:28:52 AM | 8/10/2021 11:58:43 AM | termination | <br/><b>Journal Number</b>: [685976] | 27 | 3 | 577 | 12 | 12 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:52:21.660Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:53:03.941Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T09:21:36.753Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:56:49.882Z"}] | 6 | 107 | 8/10/2021 11:58:43 AM | 12 | 12 | 173 | ||||||||||||||||||||
| 0 | 409 | 8/17/2020 12:32:27 PM | 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.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 | 575 | 34 | 34 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:53:05.618Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:54:30.654Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T07:07:38.001Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 8/17/2020 10:23:05 AM | 3/15/2021 4:53:44 AM | late termination | 4 | 3 | 14 | 2 | 23 | 14 | |||||||||||||||||||||||||||||||||
| 0 | 407 | 8/17/2020 9:29:30 AM | 11/5/2021 12:39:52 PM | water query | no valid query details submitted | 27 | 3 | 570 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:18:07.754Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:47:00.520Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-05T12:38:42.994Z"}] | 1 | 44 | 11/5/2021 12:39:52 PM | 14 | 14 | 3 |