Dreams:pattern: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 18: | Line 18: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(2 AS ?order) | ||
BIND("Subject (text)" AS ?description) | BIND("Subject (text)" AS ?description) | ||
?pattern dreamst:P47 ?value . | ?pattern dreamst:P47 ?value . |
Revision as of 16:14, 19 October 2022
Pattern data
PREFIX target: <https://dreams.wikibase.cloud/entity/Q260> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT DISTINCT ?description ?value ?valueLabel ?valueUrl WHERE { BIND(target: AS ?pattern) { BIND(1 AS ?order) BIND("Subject (effector)" AS ?description) ?pattern dreamst:P33 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(2 AS ?order) BIND("Subject (text)" AS ?description) ?pattern dreamst:P47 ?value . } UNION { BIND(4 AS ?order) BIND("Object (class)" AS ?description) ?pattern dreamst:P34 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(5 AS ?order) BIND("Object (text)" AS ?description) ?pattern dreamst:P49 ?value . } UNION { BIND(10 AS ?order) BIND("Recipient" AS ?description) ?pattern dreamst:P34 / dreamst:P9 ?value . ?value dreamst:P10+ dreams:Q50 . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(15 AS ?order) BIND("Quote" AS ?description) ?pattern dreamst:P18 ?value . } UNION { BIND(20 AS ?order) BIND("Report" AS ?description) ?pattern dreamst:P20 ?value . BIND(CONCAT("#report/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(25 AS ?order) BIND("Project type" AS ?description) { ?pattern dreamst:P16 ?value_from_pattern . } UNION { ?pattern dreamst:P20 / dreamst:P16 ?value_from_report . } BIND(COALESCE(?value_from_pattern, ?value_from_report) AS ?value) BIND(CONCAT("#projecttype/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(26 AS ?order) BIND("Project phase" AS ?description) ?pattern dreamst:P19 ?value . BIND(CONCAT("#projectphase/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(30 AS ?order) BIND("Miljøportal" AS ?description) ?pattern dreamst:P20 / dreamst:P40 ?value_ . OPTIONAL { ?pattern dreamst:P46 ?page } BIND(CONCAT(STR(?value_), IF(BOUND(?page), CONCAT(" (page ", ?page, ") ↗"), " ↗")) AS ?value) BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?value_), IF(BOUND(?page), CONCAT("#page=", ?page), "")) AS ?valueUrl) } SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } } ORDER BY ?order