Sorting capabilities in list entity operation [pending: orderBy=$near]

[fgalan]

Eg:

http://broker.example.org/entities?type=Room&q=temperature<=22&sort=seatNumber

The parameter could be also used with a sequence of attributes, e.g sort=seatNumber,temperature. ASC and DESC order are specified with a + (default) and - prefix.

sort=+seatNumber,-temperature

Feasibility assessment with Mongo shell: https://gist.github.com/fgalan/efd63ef261fa33d91784

[fgalan]

Sorting by creDate and modDate (definitive names pending) should be also possible.

[fgalan]

SOF answers that need to be edited when this issue gets completed: http://stackoverflow.com/questions/32703011/change-order-of-orion-response/32712248#32712248

[fgalan]

Take into account talso sort by "nearest point". This PR may be useful: #1651.

[fgalan]

SOF answer that need to be edited when this issue gets completed: http://stackoverflow.com/questions/35172155/orion-context-broker-nearest-to-point-query

[fgalan]

Code implementation completed in PR #1815. However, let's keep this issue opened while doc for NGSIv2 get reviewed (and eventually updated) and the questions in SOF edited.

[fgalan]

At the end, the name of the URI parameter (to use in the documentation) is orderBy

[fgalan]

Doc modifications describing orderBy implemented in PR #1818. However, let's keep this issue opened until orderBy=$near orderBy=geo:proximity gets implemented (issue name will be adjusted).

[fgalan]

• orderBy=geo:proximity implemented in PR ADD geo:proximity orderBy #1824
• orderBy=dateCreation and orderBy=dateModification implemented in PR dateModification and dateCreation #1829

[fgalan]

QA Acceptance Test pending. Reopened and asigned to QATestPending milestone.

[iariasleon]

pending tests are created in its feature associated

[fgalan]

Issues in milestone QATestPendingNotE2ECovered are going to be closed (it is not realistic to think we would have people working on behave testing at the present moment). However, issue is labeled with QATestPending label in the case things change and we need to recover it.