Project Operator
Overview
Choose which fields to return, while optionally renaming them and/or calculating new ones using project
.
Examples
Return only certain fields
The query below returns only the p_event_time
and clientIp
fields:
{ "p_event_time": "2023-09-16 05:45:34.863", "clientIp": "192.168.11.34" }
{ "p_event_time": "2023-09-16 05:59:04.058", "clientIp": "192.168.1.1" }
{ "p_event_time": "2023-09-16 05:36:09.017", "clientIp": "10.168.22.7" }
{ "p_event_time": "2023-09-16 05:36:09.017", "clientIp": "10.168.22.1" }
Rename fields
{ "p_event_time": "2023-09-16 05:45:34.863", "client": "192.168.11.34" }
{ "p_event_time": "2023-09-16 05:59:04.058", "client": "192.168.1.1" }
{ "p_event_time": "2023-09-16 05:36:09.017", "client": "10.168.22.7" }
{ "p_event_time": "2023-09-16 05:36:09.017", "client": "10.168.22.1" }
Calculate new fields
This functionality is similar to the extend
operator.
{ "p_event_time": "2023-09-16 05:45:34.863", "client": "192.168.11.34", "is_http_11": true }
{ "p_event_time": "2023-09-16 05:59:04.058", "client": "192.168.1.1", "is_http_11": true }
{ "p_event_time": "2023-09-16 05:36:09.017", "client": "10.168.22.7", "is_http_11": false }
{ "p_event_time": "2023-09-16 05:36:09.017", "client": "10.168.22.1", "is_http_11": true }
Last updated
Was this helpful?