Nested Queries

[nabeelrehman2114]

Is there any way to use nested query something like this select ActivityId from stream where appName = 'appName' and Id = (select Id from stream where name = 'Name') ?

[liammclennan]

Hi @nineralpha,
Currently you need two queries to do this.

[efurban]

how do we do this in a dashboard query? could I have two queries at the same time?

[nblumhardt]

Hi @efurban; it's likely the same limitation will prevent this being done on a dashboard, but if you send an example of the kind of query and chart you want to generate, we may have some ideas. Cheers!

[efurban]

sure , here is an example, output as a pie chart. thanks.

select 
count(*) as Count
from stream
where Environment = 'Production'  
and @EventType = 0x205600AC 
and @Properties['ivp_owspricing_priceupdate'] is not null
and @Properties['ivp_owspricing_priceupdate'].pnl_date = (
    select max(@Properties['ivp_owspricing_priceupdate'].pnl_date) 
    from stream
    where Environment = 'Production'  
    and @EventType = 0x205600AC 
    and @Properties['ivp_owspricing_priceupdate'] is not null
)
group by 
    @Properties['ivp_owspricing_priceupdate'].dealer.dealer_name
    ```

[nblumhardt]

I don't think this can be computed in one query/presented as a pie by Seq currently, but we'll take a look at what might be involved - thanks for the example!

[nblumhardt]

See also #2050, which is tracking this.