Can Seq Support Subquery?

[dengyakui]

Some times, I have some queries like below, but since the subquery feature was not supported by Seq yet, i can's do this query.

in the above query:

1. filter the requestId by the reponse body's some status or message flag

{  "customResponseCode": 500 }

2. select the payloads from request by above log's requestId

it was equalivelant to sql's in query, like:

select * from product 
where productId in 
(select productId from orders where blabla)
where blabla

and below pseudocode is just what I want to do:

// filter bad request ids
var requestIds = stream.where(l=>l.ReqeustPath='/api/xxx')
.GroupBy(l=>l.RequestId)
.Where(g=>g.any(l=>l.ResponseBody.SomeFlag=false))
.select (g=>g.Key)

// fetch payloads by request ids
var requestPayloads = stream.where(x=>x.RequestID in requestIds).Select( l=> l.Request.Body)

[nblumhardt]

Thanks for reaching out. Right now, no, but this is definitely on our radar for a future milestone, we'll be reviewing our priorities early in the new year and will update this ticket with some more information then.