allegrograph - Sparql - alphabetical sorting issue -
i use allegrograph , sparql query results. trying sort based on alphabetical order, sparql gives upper case more preference. below analogous data , query resembles issue.
data:
<http://mydomain.com/person1> <http://mydomain.com/name> "john"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#xmlliteral> <http://mydomain.com/person1> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://mydomain.com/person> <http://mydomain.com/person2> <http://mydomain.com/name> "abraham"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#xmlliteral> <http://mydomain.com/person2> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://mydomain.com/person> <http://mydomain.com/person3> <http://mydomain.com/name> "edward"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#xmlliteral> <http://mydomain.com/person3> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://mydomain.com/person>
i trying sort based on alphabetical order on names - result should abraham, edward , john. result abraham, john , edward since edward starts smaller case. please let me know how achieve this.
query:
select ?person ?name { ?person <http://mydomain.com/name> ?name. ?person <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://mydomain.com/person>. } order asc(str(?name))
sparql 1.1: order asc(ucase(str(?name)))
Comments
Post a Comment