Difference between revisions of "Report"

From Wikibase Personal data
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{SPARQL|state=collapsed
+
{{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 .
Line 8: 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)))
 
}}
 
}}
  
  
{{SPARQL|state=collapsed
+
{{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 .
Line 21: 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)))

items pointing to either PDIO or POD (embedded)