Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
model:customcoll [2013/01/10 17:31]
giancarlo
model:customcoll [2013/01/10 17:49]
giancarlo
Line 10: Line 10:
  
  
-  * **List all collections of books (not collections of collections) and count total pages and books**+**__List all collections of books (not collections of collections) and count total pages and books__**
   * DSID QUERY   * DSID QUERY
  
Line 64: Line 64:
 </WRAP> </WRAP>
  
-  * **List all parents of collections of books and count total pages and books**+**__List all parents of collections of books and count total pages and books__**
   * DSID QUERY   * DSID QUERY
  
Line 135: Line 135:
 </WRAP> </WRAP>
  
-  * **List all parents and collections of books and count total pages, books and collections**+**__List all parents and collections of books and count total pages, books and collections__**
   * DSID QUERY   * DSID QUERY
  
Line 266: Line 266:
   </xsl:template>   </xsl:template>
 </xsl:stylesheet> </xsl:stylesheet>
 +</code>
 +</WRAP>
 +
 +**__Repository statistics__**
 +  * DSID QUERY
 +
 +<code>
 +select $ordine $colle $titlecolle
 +count(
 + select $object
 + from <#ri>
 + where walk($object <fedora-rels-ext:isMemberOfCollection> $colle
 + and $libro <fedora-rels-ext:isMemberOfCollection> $object)
 + and $pagine <fedora-rels-ext:isMemberOf> $libro)
 +count(
 + select $libro
 + from <#ri>
 + where walk($object <fedora-rels-ext:isMemberOfCollection> $colle
 + and $libro <fedora-rels-ext:isMemberOfCollection> $object)
 + and $libro <fedora-model:hasModel> <info:fedora/islandora:bookCModel>)
 +count(
 + select $pagine
 + from <#ri>
 + where walk($object <fedora-rels-ext:isMemberOfCollection> $colle
 + and $libro <fedora-rels-ext:isMemberOfCollection> $object)
 + and $pagine <fedora-rels-ext:isMemberOf> $libro)
 +from <#ri>
 +where ((($colle <fedora-rels-ext:isMemberOfCollection> <info:fedora/islandora:root>
 +minus
 +$colle <mulgara:is> <info:fedora/openbess:collezioni>)
 +and $ordine <mulgara:is> '3')
 +or ($colle <fedora-rels-ext:isMemberOfCollection> <info:fedora/openbess:collezioni>
 +and $ordine <mulgara:is> '2')
 +or ($colle <mulgara:is> <info:fedora/islandora:root>
 +and $ordine <mulgara:is> '1'))
 +and $colle <dc:title> $titlecolle
 +order by $ordine $titlecolle
 +</code>
 +
 +  * DSID QUERYCOLLECTION_VIEW
 +
 +<WRAP prewrap center>
 +<code xml>
 +
 </code> </code>
 </WRAP> </WRAP>
  
 
 
model/customcoll.txt ยท Last modified: 2013/01/10 17:53 by giancarlo

Developers: CNR IRCrES IT Office and Library
Giancarlo Birello (giancarlo.birello _@_ ircres.cnr.it) and Anna Perin (anna.perin _@_ ircres.cnr.it)
DigiBess is licensed under: Creative Commons License
Recent changes RSS feed Creative Commons License Valid XHTML 1.0 Valid CSS Driven by DokuWiki
Drupal Garland Theme for Dokuwiki