Critical Description
Sample:
00:00:02.437958| [Query]: {Query#1913610} Compiling JSON query: {"WHAT":[["._id"]],"WHERE":["AND",["AND",["AND",["=",[".docType"],9],["=",[".installationID"],"2C3E0A23-7806-4BCC-9C77-9B6F7D613CF5"]],["<=",[".triggerDate"],1710532802000]],["!=",[".triggerDate"],0]],"FROM":[{"AS":"QuanticSocketDatabase"}]} |
00:00:02.438656| [Query]: {Query#1913610} Compiled as SELECT fl_result(QuanticSocketDatabase.key) FROM kv_default AS QuanticSocketDatabase WHERE (((fl_value(QuanticSocketDatabase.body, 'docType') = 9 AND fl_value(QuanticSocketDatabase.body, 'installationID') = '2C3E0A23-7806-4BCC-9C77-9B6F7D613CF5') AND fl_value(QuanticSocketDatabase.body, 'triggerDate') <= 1710532802000) AND fl_value(QuanticSocketDatabase.body, 'triggerDate') != 0) AND (QuanticSocketDatabase.flags & 1 = 0) |
00:00:02.439666| [Query]: {QueryEnum#1913611} Created on {Query#1913610} with 0 rows (2 bytes) in 0.175ms |
00:00:02.439911| [Query]: Beginning query enumeration (0x2801bddd0) |
00:00:02.440200| [Query]: End of query enumeration (0x2801bddd0) |
00:00:02.440318| [Query]: {QueryEnum#1913611} Deleted |
Problems : When the customers sent us sthe text log files that have a large number of logs from multiple days, a manual process to separate logs file by day (not date) is required before being able to merge and sort the logs.