Template:Workflow: Difference between revisions
From MaRDI portal
(6 intermediate revisions by the same user not shown) | |||
Line 452: | Line 452: | ||
?Proprietary | ?Proprietary | ||
?toPublish | ?toPublish | ||
?toArchive | |||
WHERE { | WHERE { | ||
Line 505: | Line 506: | ||
# Proprietary | # Proprietary | ||
BIND(IF(EXISTS { ?inputID wdt:P31 wd:Q6480367 }, "yes", IF(EXISTS { ?inputID wdt:P31 wd:Q6480313 }, "no", "" )) AS ?Proprietary) | BIND(IF(EXISTS { ?inputID wdt:P31 wd:Q6480367 }, "yes", IF(EXISTS { ?inputID wdt:P31 wd:Q6480313 }, "no", "" )) AS ?Proprietary) | ||
# Bind DOI and URL if they exist | |||
OPTIONAL { ?inputID wdt:P23 ?doi. } | |||
OPTIONAL { ?inputID wdt:P188 ?url. } | |||
# Data Publishing | # Data Publishing | ||
BIND(IF(EXISTS { ?inputID wdt:P1563 wd:Q6480291 }, "yes | BIND( | ||
IF(EXISTS { ?inputID wdt:P1563 wd:Q6480291 }, | |||
IF(EXISTS { ?inputID wdt:P27 ?doi }, | |||
CONCAT('<a href="', 'https://dx.doi.org', STR(?doi), '">yes</a>'), | |||
IF(EXISTS { ?inputID wdt:P188 ?url }, | |||
CONCAT('<a href="', STR(?url), '">yes</a>'), | |||
"yes" | |||
) | |||
), | |||
"no" | |||
) AS ?toPublish | |||
) | |||
# Data Archiving | |||
OPTIONAL { | |||
?inputID p:P1563 ?statementNode. | |||
?statementNode ps:P1563 wd:Q6480370. | |||
OPTIONAL { | |||
?statementNode pq:P411 ?endTime. | |||
} | |||
} | |||
BIND( | |||
IF(BOUND(?statementNode), | |||
IF(BOUND(?endTime), | |||
STR(?endTime), | |||
"yes" | |||
), | |||
"no" | |||
) AS ?toArchive | |||
) | |||
} | } | ||
} GROUP BY ?ID ?Name ?Size ?DataStructure ?ExchangeFormat ?BinaryOrText ?Proprietary ?toPublish | } GROUP BY ?ID ?Name ?Size ?DataStructure ?ExchangeFormat ?BinaryOrText ?Proprietary ?toPublish ?toArchive | ||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable |
Latest revision as of 13:19, 12 December 2024