Get-CosmosDbDocument not able to query certain items from a container

[Sachin27j]

Get-CosmosDbDocument not able to query certain items from a container

[Sachin27j]

Did some more digging, apparently the query is only running for one physical partition, while there exists 2 partitions for the collection I am running it for.
Anyone with any information related to this?

[PlagueHO]

Hi @Sachin27j - Because you're doing a cross partition query (using the -QueryEnableCrossPartition parameter), it should be executing the query on all physical partitions. So, I don't see why your query wouldn't return the results you expect.

Have you run the same query in the Azure Portal in the Cosmos DB explorer - and do you get the same output?

[IAmWhitBran]

Hi, I am also getting this issue (or similar).
I have run the same query from the Azure portal as I have in my powershell instance. Powershell returns no record, Azure portal returns 1.

EDIT:
To update further, I can get the record to return by specifying the document id and partition key, though this does defeat the point of my cross partition query...