Does DocumentDB query support nested query?

Question

I'd like to query the document DB with a query like this:

SELECT * FROM c 
WHERE (
    c.ReportType = 'MyReport' 
    And c.TenantId='testTenantId_111111' 
    And c._ts = (
        SELECT Top 1 c._ts FROM c 
        WHERE (c.ReportType = 'MyReport' And c.TenantId='testTenantId_111111') 
        order by c._ts Desc
    )
)

But it does not work.

Does document DB support this kind of query?

Not sure if this is a contrived example or the real deal, but... it looks like this example can be done in a single query. — David Makogon
– David Makogon, Commented Sep 14, 2016 at 0:35
Hi, David, this is just an example, but I'm still want to know how to do it in one query in documentDB? thanks. — urlreader
– urlreader, Commented Sep 14, 2016 at 15:14

Larry Maccherone · Accepted Answer · 2016-09-13 22:45:32Z

1

It does not support nested queries. You have to query twice. If you need consistency between the two queries, you can do both from within a stored procedure.

answered Sep 13, 2016 at 22:45

Larry Maccherone

9,5433 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Does DocumentDB query support nested query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related