Matches in Nanopublications for { ?s ?p ?o <https://w3id.org/np/RAYtPECxCxpoEIAQuB0WJtDMw7TQjZFLt938It2oo6IgQ/assertion>. }
Showing items 1 to 6 of
6
with 100 items per page.
- get-active-users-last-6m type grlc-query assertion.
- get-active-users-last-6m label "Get active users of last 6 months" assertion.
- get-active-users-last-6m description "This query returns the user IDs of all active users of the last 6 months." assertion.
- get-active-users-last-6m sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?user where { { graph npa:graph { bind(now() - "P6M"^^xsd:duration as ?sixmonthsago) ?np dct:creator ?user . ?np dct:created ?date . filter(?date > ?sixmonthsago) } } union { graph npa:graph { bind(now() - "P6M"^^xsd:duration as ?sixmonthsago) ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . ?np dct:created ?date . filter(?date > ?sixmonthsago) } graph ?prov { ?assertion prov:wasAttributedTo ?user . } } filter not exists { graph npa:graph { ?np npa:hasSubIri ?user . } } } order by ?user" assertion.
- get-active-users-last-6m endpoint full assertion.
- get-active-users-last-6m license LICENSE-2.0 assertion.