Please help me setting the filter plugin for the following scenario.
Say I have the following scenario
INFO - 12345 - TASK_START - start
INFO - 12345 - SQL - sqlQuery1 - 12
INFO - 12345 - SQL - sqlQuery2 - 34
INFO - 12345 - SQL - sqlQuery3 - 44
INFO - 12345 - TASK_END - end
If I am aggregating using taskid (12345), there are two things, I want to do.
One is just existence check whether sqlQuery1 happened or not
Other is basically collect all the fields, so that my final single document looks like.
(Assumption sqlQuery2 and sqlQuery3 always happen/present)
task id 12345
sqlQuery1PresentOrNot (boolean) true
sqlQuery1Time 12 (optional field )
Is Aggregate filter plugin the right one for my above scenario or any other plugins can help in as well.