Share you sparql queries or best sparql resources for Fedora.

[Jennifer Eustis]

Hi folks,

I just began learning sparql. I've found some resources on the Duraspace wiki and a couple of other places but not much to tell you the truth. I thought it would be great if people were willing to share their favorite resources for sparql recipes for Fedora or their favorite queries. This information can be added to the Islandora Metadata IG wiki or another wiki as a easy to access references. When sharing, don't forget to add what your query is supposed to do and which version of Fedora.

Best,

Jennifer

[Phil R]

Here's my list of collected sparql queries using the fedora resource index query service. Works for Fedora 3.6.2:

Get all fedora objects

SELECT ?obj 
FROM <#ri>
WHERE {
?obj <info:fedora/fedora-system:def/model#hasModel> <info:fedora/fedora-system:FedoraObject-3.0> .
}

Get all datastreams

SELECT ?obj ?ds
FROM <#ri>
WHERE {
?obj <info:fedora/fedora-system:def/view#disseminates> ?ds .
}

Get all BookCModel collection objects

SELECT ?object
WHERE {
  ?object <fedora-model:hasModel> <info:fedora/islandora:bookCModel> .
}

Get all members of a collection

SELECT *
FROM <#ri>
WHERE {
?o <fedora-rels-ext:isMemberOfCollection> <info:fedora/PID> ;
}

And using the api

Count all islandora:pageCModel objects

http://example.com:8080/fedora/risearch?dt=on&format=count&lang=sparql&limit=&query=SELECT%20%3Fobject%0D%0AWHERE%20{%0D%0A%20%20%3Fobject%20%3Cfedora-model%3AhasModel%3E%20%3Cinfo%3Afedora%2Fislandora%3ApageCModel%3E%20.%0D%0A}&type=tuples

[Jennifer Eustis]

Thanks Phil.

Here's one of my test ones to get a particular list of pids and labels by ownerId

PREFIX dc: <http://purl.org/dc/elements/1.1/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX fedora-model: <info:fedora/fedora-system:def/model#>

PREFIX fedora-view: <info:fedora/fedora-system:def/view#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?pid ?label ?ownerId

WHERE

{

?pid fedora-model:label ?label;

     fedora-model:ownerId ?ownerId .

FILTER(regex(?ownerId, "jeustis")) .

}

LIMIT 500 

[Ernie Gillis]

I have a couple of queries I can post when I'm at my desk at work.
In mean time, I'm curious which links you found useful in documentation, Jennifer. You mention the wiki, and such, but would you mind linking to them? Thank you!! :)

[Jennifer Eustis]

Great point Ernie...

Here's what I found:

https://wiki.duraspace.org/display/FEDORA37/Resource+Index+Search

http://islandora.ca/sites/default/files/Don%E2%80%99t%20be%20Dreary,%20Let%E2%80%99s%20Query!.pdf (love the title!)

There are tons of resources on sparql but my searches that pertain to Fedora and in particular version 3.7 came up rather short.

Jennifer