Difference between revisions of "Report"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
OPTIONAL {?s pdiot:P33 ?reference}. | 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))) |
}} | }} | ||
| Line 19: | Line 19: | ||
OPTIONAL {?s pdiot:P33 ?reference}. | 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)))