Difference between revisions of "Report"
Jump to navigation
Jump to search
(Created page with "{{SPARQL|state=collapsed |label=items pointing to POD |query=select ?s ?sLabel ?p ?pLabel ?date { ?s ?pd pdio:Q351 . ?p wikibase:directClaim ?pd . OPTIONAL {?s pdiot:P10...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{SPARQL | + | {{SPARQL|label=items pointing to POD |
| − | |label=items pointing to POD | + | |query=select ?s ?sLabel ?p ?pLabel ?date ?official ?reference { |
| − | |query=select ?s ?sLabel ?p ?pLabel ?date { | ||
?s ?pd pdio:Q351 . | ?s ?pd pdio:Q351 . | ||
?p wikibase:directClaim ?pd . | ?p wikibase:directClaim ?pd . | ||
OPTIONAL {?s pdiot:P100 ?date}. | OPTIONAL {?s pdiot:P100 ?date}. | ||
| + | OPTIONAL {?s pdiot:P15 ?official}. | ||
| + | OPTIONAL {?s pdiot:P33 ?reference}. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
| − | } | + | } ORDER BY (UCASE(str(?date))) |
}} | }} | ||
| − | {{SPARQL | + | {{SPARQL|label=items pointing to PDIO |
| − | |label=items pointing to PDIO | + | |query=select ?s ?sLabel ?p ?pLabel ?date ?official ?reference { |
| − | |query=select ?s ?sLabel ?p ?pLabel ?date { | ||
?s ?pd pdio:Q182 . | ?s ?pd pdio:Q182 . | ||
?p wikibase:directClaim ?pd . | ?p wikibase:directClaim ?pd . | ||
OPTIONAL {?s pdiot:P100 ?date}. | OPTIONAL {?s pdiot:P100 ?date}. | ||
| + | OPTIONAL {?s pdiot:P15 ?official}. | ||
| + | OPTIONAL {?s pdiot:P33 ?reference}. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
| − | } | + | } ORDER BY (UCASE(str(?date))) |
| + | }} | ||
| + | |||
| + | |||
| + | |||
| + | {{SPARQL|label=items pointing to either PDIO or POD | ||
| + | |query=select ?targetLabel ?s ?sLabel ?p ?pLabel ?date ?official ?reference { | ||
| + | ?s ?pd ?target . | ||
| + | VALUES ?target { | ||
| + | pdio:Q182 # PDIO | ||
| + | pdio:Q351 # POD | ||
| + | } | ||
| + | MINUS {?s pdiot:P229 ?_} # not data subject | ||
| + | ?p wikibase:directClaim ?pd . | ||
| + | OPTIONAL {?s pdiot:P100 ?date}. | ||
| + | OPTIONAL {?s pdiot:P15 ?official}. | ||
| + | OPTIONAL {?s pdiot:P33 ?reference}. | ||
| + | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
| + | } ORDER BY (UCASE(str(?date))) | ||
}} | }} | ||
Latest revision as of 11:38, 24 July 2020
PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
select ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
?s ?pd pdio:Q351 .
?p wikibase:directClaim ?pd .
OPTIONAL {?s pdiot:P100 ?date}.
OPTIONAL {?s pdiot:P15 ?official}.
OPTIONAL {?s pdiot:P33 ?reference}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY (UCASE(str(?date)))
items pointing to POD (embedded)
PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
select ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
?s ?pd pdio:Q182 .
?p wikibase:directClaim ?pd .
OPTIONAL {?s pdiot:P100 ?date}.
OPTIONAL {?s pdiot:P15 ?official}.
OPTIONAL {?s pdiot:P33 ?reference}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY (UCASE(str(?date)))
items pointing to PDIO (embedded)
PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
select ?targetLabel ?s ?sLabel ?p ?pLabel ?date ?official ?reference {
?s ?pd ?target .
VALUES ?target {
pdio:Q182 # PDIO
pdio:Q351 # POD
}
MINUS {?s pdiot:P229 ?_} # not data subject
?p wikibase:directClaim ?pd .
OPTIONAL {?s pdiot:P100 ?date}.
OPTIONAL {?s pdiot:P15 ?official}.
OPTIONAL {?s pdiot:P33 ?reference}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY (UCASE(str(?date)))