'Azure Cosmos DB Stored Procedure | Select and Return Multiple Documents Without Partition Id Value

I want to select top N documents from container by stored procedure. But it forces you to give a partition id value. But my query doesn't depend on partition id, I don't even use WHERE clause. My query:

SELECT TOP 100 * FROM Clans ORDER BY Clans.whp DESC

How can I omit partition id value? Or shouldn't I use stored procedures? I know I can make a SQL query request by Cosmos DB SDK.

azureazure-cosmosdb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions