通过在Azure Web Document Explorer中不工作进行订购 [英] Order By not working in Azure Web Document Explorer

问题描述

我正在尝试在Azure Web文档资源管理器中查询documentdb.问题是Order By似乎不再起作用.

I am trying to query documentdb inside the Azure Web Document Explorer. The problem is Order By doesn't seem to work anymore.

例如以下查询:

SELECT * FROM c
WHERE c.type="myType" ORDER BY c.createdDate 

查询时，我会收到红色警报，说明:

When queried I get a red alert stating:

Failed to get documents. Please try again.

如果我删除Order By，它可以正常工作. 知道为什么用Order By查询不再起作用了吗?

If I remove Order By it works fine. Any idea why it doesn't work anymore to query with Order By?

推荐答案

有人知道为什么用Order By查询不再有效吗?

Any idea why it doesn't work anymore to query with Order By?

当以最大精度(-1)进行范围索引时，只能针对数字或字符串的属性指定

订购依据.有关更多详细信息，请参阅文档

Order By can be specified only against a property, either numeric or String when it is range indexed with the Maximum Precision (-1). More detail please refer to document

您也不能执行以下操作:

You also cannot perform the following:

Order By具有内部字符串属性，例如id，_rid和_self(即将推出).

Order By with internal string properties like id, _rid, and _self (coming soon).

Order By具有从文档内联接的结果派生的属性(即将推出).

Order By with properties derived from the result of an intra-document join (coming soon).

通过多个属性订购(即将推出).

Order By multiple properties (coming soon).

通过查询数据库，集合，用户，权限或附件(即将推出)进行订购.

Order By with queries on databases, collections, users, permissions or attachments (coming soon).

排序依据，例如表达式或UDF/内置函数的结果

Order By with computed properties e.g. the result of an expression or a UDF/built-in function

这篇关于通过在Azure Web Document Explorer中不工作进行订购的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！