Hi, GROUP_CONCAT is the feature you are looking for. https://www.w3.org/TR/sparql11-query/#defn_aggGroupConcat
It does mean you need to do a GROUP_BY Regards, Jerven On 04/12/2017 06:05 PM, Legault, Phillip [GTSUS] wrote: > I was wondering if anyone knows how to get an array of results from a > single property to end up into one result cell. > > > > PREFIX > property:<http://server.com/index.php/Special:URIResolver/Property-3A> > > PREFIX swivt:<http://semantic-mediawiki.org/swivt/1.0#> > > PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> > > PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> > > SELECT ?Name ?Category ?Decision_By ?Topic ?Publication_Status > ?Publication_Date > > WHERE > > { > > ?s ?p ?cat . > > ?cat rdfs:label ?Category . > > ?cat rdfs:label "LADR" . > > FILTER(CONTAINS(STR(?cat), "Category")) . > > ?s property:Has_Name ?Name . > > FILTER regex(?Name, "{{{LADR|}}}", "i") . > > OPTIONAL { ?s property:Decision_By ?Decision_By. } > > OPTIONAL { ?s property:Has_Topic ?Topic. } > > OPTIONAL { ?s property:PublicationStatus ?Publication_Status. } > > OPTIONAL { ?s property:PublicationDate ?Publication_Date. } > > > > > > } > > > > I end up with multiple lines of results for the same page > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- ------------------------------------------------------------------- Jerven Bolleman Jerven.Bolleman@sib.swiss SIB Swiss Institute of Bioinformatics Tel: +41 (0)22 379 58 85 CMU, rue Michel Servet 1 Fax: +41 (0)22 379 58 58 1211 Geneve 4, Switzerland www.sib.swiss - www.uniprot.org Follow us at https://twitter.com/#!/uniprot ------------------------------------------------------------------- ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
