Difference between revisions of "Report"
Jump to navigation
Jump to search
| 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))) |
}} | }} | ||
| Line 37: | Line 37: | ||
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))) |
}} | }} | ||
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)))