Skillnad mellan versioner av "Stockholms universitetsbibliotek"
Hoppa till navigering
Hoppa till sök
Gunillar (diskussion | bidrag) (Skapade sidan med ' == Antal lån via utlåningsmaskin == <pre> SELECT COUNT(s.itemnumber) AS antal FROM statistics s LEFT JOIN action_logs a ON (s.itemnumber=a.object AND s.datetime=a.timestamp...') |
|||
Rad 10: | Rad 10: | ||
AND date(datetime) BETWEEN <<Startdatum|date>> | AND date(datetime) BETWEEN <<Startdatum|date>> | ||
AND <<Slutdatum|date>> | AND <<Slutdatum|date>> | ||
+ | </pre> | ||
+ | |||
+ | ==Bestånd utifrån DDK-klassifikation i den bibliografiska posten (fält 082) på vald enhet (homebranch), location== | ||
+ | <pre> | ||
+ | SELECT | ||
+ | i.itemcallnumber, | ||
+ | b.author, | ||
+ | b.title, | ||
+ | i.barcode, | ||
+ | ExtractValue (bm.metadata,'//datafield[@tag="035"]/subfield[@code="a" and contains(text(), "LIBRIS")]') AS 'LibrisID', | ||
+ | ExtractValue(bm.metadata, '//datafield[@tag="082"]/subfield[@code="a"]') AS 'Dewey', | ||
+ | ExtractValue(bm.metadata, '//datafield[@tag="084"]/subfield[@code="a"]') AS 'SAB', | ||
+ | b.copyrightdate, | ||
+ | i.itype AS 'Item type', | ||
+ | i.onloan AS 'Utlånad', | ||
+ | i.itemlost, | ||
+ | i.homebranch, | ||
+ | i.location, | ||
+ | b.biblionumber, | ||
+ | i.itemnumber | ||
+ | FROM items i | ||
+ | LEFT JOIN biblio_metadata bm ON (i.biblionumber=bm.biblionumber) | ||
+ | LEFT JOIN biblio b ON (bm.biblionumber=b.biblionumber) | ||
+ | WHERE i.homebranch = <<Välj enhet|branches>> | ||
+ | AND i.location = <<Välj location|LOC>> | ||
+ | AND ExtractValue(bm.metadata, '//datafield[@tag="082"]/subfield[@code="a"]') LIKE <<Skriv början på Deweykod ex 839%>> | ||
+ | ORDER BY i.itemcallnumber | ||
</pre> | </pre> |
Versionen från 28 mars 2019 kl. 14.17
Antal lån via utlåningsmaskin
SELECT COUNT(s.itemnumber) AS antal FROM statistics s LEFT JOIN action_logs a ON (s.itemnumber=a.object AND s.datetime=a.timestamp) WHERE s.branch = <<Välj enhet|branches>> AND s.`type` = 'issue' AND a.user = <<Skriv borrower id för utlåningsmaskin>> AND date(datetime) BETWEEN <<Startdatum|date>> AND <<Slutdatum|date>>
Bestånd utifrån DDK-klassifikation i den bibliografiska posten (fält 082) på vald enhet (homebranch), location
SELECT i.itemcallnumber, b.author, b.title, i.barcode, ExtractValue (bm.metadata,'//datafield[@tag="035"]/subfield[@code="a" and contains(text(), "LIBRIS")]') AS 'LibrisID', ExtractValue(bm.metadata, '//datafield[@tag="082"]/subfield[@code="a"]') AS 'Dewey', ExtractValue(bm.metadata, '//datafield[@tag="084"]/subfield[@code="a"]') AS 'SAB', b.copyrightdate, i.itype AS 'Item type', i.onloan AS 'Utlånad', i.itemlost, i.homebranch, i.location, b.biblionumber, i.itemnumber FROM items i LEFT JOIN biblio_metadata bm ON (i.biblionumber=bm.biblionumber) LEFT JOIN biblio b ON (bm.biblionumber=b.biblionumber) WHERE i.homebranch = <<Välj enhet|branches>> AND i.location = <<Välj location|LOC>> AND ExtractValue(bm.metadata, '//datafield[@tag="082"]/subfield[@code="a"]') LIKE <<Skriv början på Deweykod ex 839%>> ORDER BY i.itemcallnumber