Filter in map after aggregate & group by By: Milo Parsons Hi, I am using an Aggregate step with a Group By and I am trying to get a value based on another object's value. e.g. in the below example, I'd like to return the last_updated value where status = complete i.e. "2025-01-01" I tried this but it just returns true/false: $status == "Complete" ? $last_updated : null ``` [ { "status": "Complete", "last_updated": "2025-01-01" }, { "status": "Pending", "last_updated": "2025-05-01" } ] ``` Any help would be much appreciated! Thanks
By: Spiro Taleski $.filter(x => x.status == "Complete") It will produce new array containing only the objects where status = Complete. The expression will work only if the input data is array. I guess that, in your case the data is already split before the step where the expression is put (and that's the reason why it is not working). If your data is already split, then you can filter the records using Filter Snap with the following expression: $status == 'Completed' So only records with status = Completed will be sent further.
