Jamie Rees

You can see my change here: https://github.com/tidusjar/Cosmonaut/commit/c911f451df853ee00c73577551f81d015ed22b3e This fixes my issue, but It doesn't seem right.

Nested select queries does seem to work fine on the Azure Portal and returns the expected output. And it also works fine with Cosmonaut with the exception of this current...

Not sure if this helps: https://stackoverflow.com/questions/51042600/cosmosdb-subdocument-delselecting-linq-query/51121262#51121262 He is from Cosmos DB Engineering team

So all the issue really is, is in the nested query we have a `where` clause, and then in the outer query also has a `where` clause. Another example ```...

Here is another example (More complex): Original Query: ``` SELECT * FROM( SELECT DISTINCT(c.id), c.ReportArea, c.ReportConfiguration, c.CreatedBy, c.CreatedOn, c.ReportInstanceName, c.ReportName, c.ReportType, c.StoredReports, c.ReportFormat, c.BatchId, c.CosmosEntityName, ARRAY( SELECT StoredReport.ReportName, StoredReport.CreatedOn, StoredReport.URI,...

I'm not sure about the underlying sdk, but querying via Azure Portal seems to allow this. This is not really a big issue, since I've now fixed my issue to...

Thanks @mattwarren I actually subscribe to your blog! Thanks for the insight 😄

>i do not want us both to be in ASP.NET, Why?

Just going to chime in here. In my .NET version we have a background scheduler set up and we query Plex every X minutes (30) and cache the results. When...

@ersan If you have any issues please feel free to jump on Gitter to discuss anything with me, or raise an issue on the Ombi github and we can continue...