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 | 137685 | 565 | 9/16/2020 12:35:46 PM | 10/27/2021 10:02:17 AM | Log Query | log query | 4 | 3 | 799 | 33 | 33 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-10-24T09:59:25.685Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-25T09:36:31.035Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T10:02:17.910Z"}] | 1 | 50 | 13 | 10/27/2021 10:02:17 AM | 33 | 33 | 13 | ||||||||||||||||||
| 0 | 137638 | 564 | 9/16/2020 12:26:04 PM | 10/27/2021 9:59:48 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 798 | 33 | 33 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:58:36.859Z"}] | 9 | 123 | 14 | 10/27/2021 9:59:48 AM | 33 | 33 | 14 | ||||||||||||||||||
| 0 | 563 | 9/16/2020 10:32:17 AM | 2/24/2022 10:34:50 AM | Log Query | readings up-to-date | 27 | 3 | 797 | 26 | 26 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:42:10.477Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:42:40.401Z"}] | 1 | 67 | 2/24/2022 10:34:50 AM | 26 | 26 | 12 | ||||||||||||||||||||
| 0 | 562 | 9/16/2020 8:58:41 AM | 3/28/2022 6:35:04 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 793 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T12:42:59.924Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:45:01.263Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-02-25T09:42:21.413Z"}] | 9 | 123 | 14 | 3/28/2022 6:35:04 AM | 5 | 5 | 14 | |||||||||||||||||||
| 0 | 561 | 9/15/2020 1:39:00 PM | 3/28/2022 7:23:36 AM | 06 Month policy | 2019/12 back charge<br/><b>Journal Amount</b>: [-R15,283.27]<br/><b>Journal Number</b>: [BJ71071440] | 27 | 3 | 792 | 34 | 13 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-18T14:00:21.422Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-09-22T12:19:04.680Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:39:10.803Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T08:45:16.837Z"}] | 1 | 101 | 11 | 3/28/2022 7:23:36 AM | 13 | 34 | 11 | |||||||||||||||||||
| 0 | 560 | 9/15/2020 12:56:52 PM | 7/21/2021 7:53:21 AM | Water query | no valid query details submitted | 27 | 3 | 791 | 14 | 14 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:18:53.100Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:54:29.725Z"}] | 1 | 45 | 7/21/2021 7:53:21 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 559 | 9/15/2020 12:38:49 PM | 7/21/2021 8:13:02 AM | Water query | no valid query details submitted | 27 | 3 | 790 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:27:11.737Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:14:10.875Z"}] | 1 | 44 | 7/21/2021 8:13:02 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 558 | 9/15/2020 12:33:59 PM | 7/21/2021 8:51:36 AM | Water query | no valid query details submitted | 27 | 3 | 789 | 14 | 14 | 2 | 23 | 1 | 48 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:22:41.029Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:51:29.540Z"}] | 1 | 48 | 7/21/2021 8:51:36 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 557 | 9/15/2020 12:28:43 PM | 7/21/2021 7:49:36 AM | Water query | no valid query details submitted | 27 | 3 | 788 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:14:48.044Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:50:27.733Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:50:51.382Z"}] | 1 | 44 | 7/21/2021 7:49:36 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 556 | 9/15/2020 12:24:37 PM | 7/21/2021 9:15:41 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 787 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:32:16.297Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:15:37.150Z"}] | 1 | 44 | 7/21/2021 9:15:41 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 135916 | 555 | 9/15/2020 11:22:20 AM | 3/28/2022 7:23:36 AM | Water Query | Account was not read please apply 06 months policy<br/><b>Journal Number</b>: [777353]<br/><b>Journal Amount</b>: [216178.82] | 25 | 3 | 786 | 9 | 13 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:38:14.479Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-13T06:43:20.675Z"}] | 1 | 101 | 4 | 3/28/2022 7:23:36 AM | 13 | 9 | 4 | ||||||||||||||||||
| 0 | 135916 | 554 | 9/15/2020 11:07:40 AM | 2/24/2022 11:21:35 AM | Water Query | Consumer is querying high consumption for the month June, please back charge the account.<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE</div><br/><b>Journal Number</b>: [768860] | 24 | 3 | 783 | 9 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T09:34:56.707Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-13T08:36:46.184Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-13T08:37:28.174Z"}] | 1 | 101 | 15 | 123764 | 9 | 15 | ||||||||||||||||||||
| 0 | 553 | 9/15/2020 10:44:44 AM | 7/21/2021 8:27:52 AM | Water query | no valid query details submitted | 27 | 3 | 782 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:16:14.272Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:27:43.784Z"}] | 1 | 44 | 7/21/2021 8:27:52 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 552 | 9/15/2020 10:41:40 AM | 7/21/2021 8:24:50 AM | Water query | no valid query details submitted | 27 | 3 | 781 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:13:55.468Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:24:44.128Z"}] | 1 | 44 | 7/21/2021 8:24:50 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 551 | 9/15/2020 10:28:17 AM | 7/21/2021 7:50:43 AM | Water query | no valid query details submitted | 27 | 3 | 780 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:16:04.481Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:51:51.357Z"}] | 1 | 44 | 7/21/2021 7:50:43 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 550 | 9/15/2020 10:25:16 AM | 7/21/2021 8:52:10 AM | Water query | no valid query details submitted | 27 | 3 | 779 | 14 | 14 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:23:13.786Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:52:06.199Z"}] | 1 | 45 | 7/21/2021 8:52:10 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 549 | 9/15/2020 10:21:52 AM | 11/12/2021 11:59:17 AM | Water query | Duplicate with ref #8794 | 27 | 3 | 778 | 14 | 14 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-02T08:24:51.288Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-07-10T08:24:13.950Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:08:39.608Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:22:06.054Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T11:59:18.012Z"}] | 1 | 96 | 11/12/2021 11:59:17 AM | 14 | 14 | 230 | ||||||||||||||||||||
| 0 | 548 | 9/15/2020 10:10:53 AM | 7/21/2021 9:07:09 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 777 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:29:41.506Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:07:05.111Z"}] | 1 | 44 | 7/21/2021 9:07:09 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 547 | 9/15/2020 10:06:28 AM | 7/21/2021 7:50:06 AM | Water query | no valid query details submitted | 27 | 3 | 776 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:15:33.268Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:51:14.359Z"}] | 1 | 44 | 7/21/2021 7:50:06 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 546 | 9/15/2020 10:03:26 AM | 7/21/2021 9:14:14 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 775 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:30:42.638Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:14:10.318Z"}] | 1 | 44 | 7/21/2021 9:14:14 AM | 14 | 14 | 14 |