SPARQL Operation support for ordering results

[chenejac]

Is your feature request related to a problem? Please describe.
For the endpoint

GET http://localhost:8080/vivo/api/rest/1.0.0/geolocation/?sortBy=limit&order=ASC

this SPARQL query should be executed

SELECT ?uri ?label 
WHERE {      
  ?uri <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://vivoweb.org/ontology/core#GeographicLocation>
  OPTIONAL { 
      ?uri <http://www.w3.org/2000/01/rdf-schema#label> ?label 
   } 
} 
ORDER BY ?order(??sortBy)

Before execution ?order(??sortBy) should be replaced with ASC(?limit). Neither ParameterizedSparqlString setLiteral, neither setIRI are working here. For the first (setLiteral), it produces "ASC^^xsdstring"(?"limit^^xsdstring"), for the second (setIRI) it produces (?).

Describe the solution you'd like
Probably ParameterizedSparqlString append method might resolve this issue, but redesign of the ontology description of SPARQL operation class might be needed.

[ghost]

SELECT ?uri ?label
WHERE {
  ?uri <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://vivoweb.org/ontology/core#GeographicLocation>
  OPTIONAL {
    ?uri <http://www.w3.org/2000/01/rdf-schema#label> ?label
  }
}
ORDER BY ?order(??sortBy)

[chenejac]

The solution should be in accordance with the extension of Dynamic API ontology - #3878. It means, the appropriate suffix will be added before the execution of the query, if there is pageable flag set to true, and sortable flag set to true, and there are URL parameters.

1. if http request is GET http://localhost:8080/vivo/api/rest/1.0.0/geolocation/?sortBy=name&order=ASC&limit=20&offset=60 and a SPARQL operation sortable is true, then the queryText = queryText + "ORDER BY ASC(name) LIMIT 20 OFFSET 60" (this should be set before execution of query)
2. if http request is GET http://localhost:8080/vivo/api/rest/1.0.0/geolocation/?sortBy=name&order=ASC and a SPARQL operation sortable is true, then the queryText = queryText + "ORDER BY ASC(name)" (this should be set before execution of query)
3. if http request is GET http://localhost:8080/vivo/api/rest/1.0.0/geolocation/?limit=20&offset=60 and a SPARQL operation sortable is true, then the queryText = queryText + "LIMIT 20 OFFSET 60" (this should be set before execution of query)

NOTE: A procedure can have more than one SPARQL Select Operations, the logic is applied only for operations which flags are turned on.