-
Type:
Change Request
-
Resolution: Unresolved
-
Priority:
Major
-
None
-
Affects Version/s: 3.2.6
-
Component/s: API (A), Frontend (F)
-
None
Documentation says
The following parameters are supported by all get methods:
- ...
- sortfield
- sortorder
- ...
But using "sortfield" and/or "sortorder" in "trend.get" call has no effect:
Example 1. Sorting by clock doesn't work
Request:
{
"auth": "...",
"id": 1,
"params": {
"time_till": 1498710000,
"time_from": 1498700000,
"sortorder": "ASC",
"sortfield": "clock",
"itemids": [
"26031",
"26032"
],
"trend": "0",
"output": [
"itemid",
"clock"
]
},
"method": "trend.get",
"jsonrpc": "2.0"
}
Response:
{
"id": 1,
"result": [
{
"clock": "1498701600",
"itemid": "26031"
},
{
"clock": "1498705200",
"itemid": "26031"
},
{
"clock": "1498708800",
"itemid": "26031"
},
{
"clock": "1498701600",
"itemid": "26032"
},
{
"clock": "1498705200",
"itemid": "26032"
},
{
"clock": "1498708800",
"itemid": "26032"
}
],
"jsonrpc": "2.0"
}
Example 2. Descending sorting by itemid doesnt' work
Request:
{
"auth": "...",
"id": 1,
"params": {
"time_till": 1498710000,
"time_from": 1498700000,
"sortorder": "DESC",
"sortfield": "itemid",
"itemids": [
"26031",
"26032"
],
"trend": "0",
"output": [
"itemid",
"clock"
]
},
"method": "trend.get",
"jsonrpc": "2.0"
}
Response:
{
"id": 1,
"result": [
{
"clock": "1498701600",
"itemid": "26031"
},
{
"clock": "1498705200",
"itemid": "26031"
},
{
"clock": "1498708800",
"itemid": "26031"
},
{
"clock": "1498701600",
"itemid": "26032"
},
{
"clock": "1498705200",
"itemid": "26032"
},
{
"clock": "1498708800",
"itemid": "26032"
}
],
"jsonrpc": "2.0"
}
applyQuerySortOptions isn't used in include/classes/api/services/CTrend.php. Neither does ORDER BY SQL clause.