Child pages
  • Fedora Resource Index

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Select objects, modification dates, and titles. Start with the 50th Fedora object, and get the next 25 objects:

No Format

select     $object $modified $title $type
from       <#ri>
where      $object <rdf:type> $type
and        $object <rdf:type> <fedora-model:FedoraObject>
and        $object <fedora-view:lastModifiedDate> $modified
and        $object <dc:title> $title
order by   $title $object
limit      25
offset     50

Count all objects that are members of the collection object iudl:10:

No Format

select count(
  select  $object
  from    <#ri>
  where   $object
          <info:fedora/fedora-system:def/relations-external#isMemberOfCollection>
          <info:fedora/iudl:10>
  )
from <#ri>
where $a $b $c

Get all collection objects:

No Format

select  $object
from    <#ri>
where   $object
        <fedora-model:hasModel>
        <info:fedora/cmodel:collection>

Get the status of the OVERVIEW datastream:

No Format

select  $state
from    <#ri>
where   <info:fedora/iudl:99732/OVERVIEW>
        <fedora-model:state>
        $state

Find all inactive items:

No Format

select  $object
from    <#ri>
where   $object
        <fedora-model:state>
        <info:fedora/fedora-system:def/model#Inactive>

Find the OwnerID for an item:

No Format

select  $ownerId
from    <#ri>
where   <info:fedora/iudl:200332>
        <info:fedora/fedora-system:def/model#ownerId>
        $ownerId

Encoding queries as URLs

All RI queries must be URL-encoded (with a tool like this one) before being added to a behavior mechanism. To manually encode a query, make the following substitutions:

Original

Replaced

#

%23

$

%24

(

%28

)

%29

/

%2F

:

%3A

<

%3C

>

%3E

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e14bc280b202a17e-a156571c-4fce4774-9ba681bd-56b12bc692a592af8ef4e0e6"><ac:plain-text-body><![CDATA[

[space]

+

]]></ac:plain-text-body></ac:structured-macro>

Do not encode the parentheses around any parameters that you want Fedora to pass in. The encoded query should be placed after a suitable base URL like

No Format

http://fedora.dlib.indiana.edu:9090/fedora/risearch?type=tuples&lang=itql&format=Sparql&query=

If no datastream parameters are being passed, remember to include a "nullbind" parameter (see Behavior Mechanisms for more detail on this). Here is a completed query that searches for the pages of a given object (linebreaks added for readability):

No Format

http://fedora.dlib.indiana.edu:9090/fedora/risearch?type=tuples&lang=itql&format=Sparql&query=select+%24page+
%24sequence+from+%3C%23ri%3E+where+%24page+%3Cinfo%3Afedora%2Ffedora-system%3Adef%2Frelations-external%23
isPartOf%3E+%3C(objuri)%3E+and+%24page+%3Chttp%3A%2F%2Fdlib.indiana.edu%2Flib%2Fxml%2Finfrastructure%2F
rdfRelations%23sequenceNumber%3E+%24sequence&dummy=(NULLBIND)