Template:Workflow: Difference between revisions

Latest revision as of 13:19, 12 December 2024

@@ Line 451: / Line 451: @@
         ?BinaryOrText
         ?Proprietary
+       ?toPublish
+       ?toArchive
 WHERE {
@@ Line 504: / Line 506: @@
    # 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
+  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
+} GROUP BY ?ID ?Name ?Size ?DataStructure ?ExchangeFormat ?BinaryOrText ?Proprietary ?toPublish ?toArchive
 | chart=bordercloud.visualization.DataTable