MPSPARQL-7: Use sql:GROUP_DIGEST instead of GROUP_BY
[mp-sparql-moved-to-github.git] / bibframe / triplestore.xml
1 <filters  xmlns="http://indexdata.com/metaproxy">
2   <filter type="sparql">
3     <defaults uri="http://bibframe.indexdata.com/sparql/"/>
4     <db path="work" schema="sparql-results">
5       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
6       <prefix>bf: http://bibframe.org/vocab/</prefix>
7       <form>SELECT
8               ?work
9               (sql:GROUP_DIGEST (?wtitle, ' ; ', 1000, 1)) AS ?title
10               (sql:GROUP_DIGEST (?creatorlabel, ' ; ', 1000, 1))AS ?creator
11               (sql:GROUP_DIGEST (?subjectlabel, ' ; ', 1000, 1))AS ?subject
12       </form>
13       <criteria>?work a bf:Work</criteria>
14
15       <criteria> OPTIONAL {
16           ?work bf:workTitle ?wt .
17           ?wt bf:titleValue ?wtitle }
18       </criteria>
19       <criteria> OPTIONAL {
20           ?work bf:creator ?creator .
21           ?creator bf:label ?creatorlabel }
22       </criteria>
23       <criteria>OPTIONAL {
24           ?work bf:subject ?subject .
25           ?subject bf:label ?subjectlabel }
26       </criteria>
27       <index type="4">?wt bf:titleValue %v FILTER(contains(%v, %s))</index>
28       <index type="1003">?creator bf:label %v FILTER(contains(%v, %s))</index>
29       <index type="21">?subject bf:label %v FILTER(contains(%v, %s))</index>
30       <index type="1016"> {
31             ?work ?op1 ?child .
32             ?child ?op2 %v FILTER(contains(STR(%v), %s))
33           }
34       </index>
35     </db>
36     <db path="works" schema="rdf">
37       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
38       <prefix>bf: http://bibframe.org/vocab/</prefix>
39       <form>CONSTRUCT {  ?work bf:title ?title . ?work bf:author ?creator . ?work bf:instanceTitle ?it }</form>
40       <criteria>?work a bf:Work</criteria>
41
42       <criteria>?work bf:workTitle ?wt</criteria>
43       <criteria>?wt bf:titleValue ?wtitle</criteria>
44       <index type="4">?wt bf:titleValue %v FILTER(contains(%v, %s))</index>
45       <criteria>?work bf:creator ?creator</criteria>
46       <criteria>?creator bf:label ?creatorlabel</criteria>
47       <index type="1003">?creator bf:label %v FILTER(contains(%v, %s))</index>
48       <criteria>?work bf:subject ?subject</criteria>
49       <criteria>?subject bf:label ?subjectlabel</criteria>
50       <index type="21">?subject bf:label %v FILTER(contains(%v, %s))</index>
51     </db>
52     <db path="instance" schema="sparql-results">
53       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
54       <prefix>bf: http://bibframe.org/vocab/</prefix>
55       <form>SELECT DISTINCT ?instance ?title ?format</form>
56       <criteria>?instance a bf:Instance</criteria>
57
58       <criteria>?instance bf:title ?title</criteria>
59       <index type="4">?instance bf:title %v FILTER(contains(%v, %s))</index>
60       <criteria>?instance bf:format ?format</criteria>
61       <index type="1013">?instance bf:format %s</index>
62
63     </db>
64   </filter>
65   <filter type="log">
66     <message>http</message>
67     <category apdu="true"/>
68   </filter>
69   <filter type="http_client">
70     <x-forwarded-for>true</x-forwarded-for>
71   </filter>
72 </filters>