References for: get-user-stats-from-userid
Full identifier: https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid
| Nanopublication | Part | Subject | Predicate | Object | Published By | Published On |
|---|---|---|---|---|---|---|
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
Get some general user statistics
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
This query returns some general user statistics in the form of number of valid/invalidated/accepted nanopublications published.
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dct: <http://purl.org/dc/terms/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix nt: <https://w3id.org/np/o/ntemplate/>
prefix bibo: <http://purl.org/ontology/bibo/>
prefix pav: <http://purl.org/pav/>
select ?key ?value where {
{
select ?key (count(?np) as ?value) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?_userid_iri .
bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } as ?invalidated )
}
bind(if(?invalidated,"invalidatedNpCount","validNpCount") as ?key)
values ?key { "invalidatedNpCount" "validNpCount" }
}
group by ?key ?invalidated
}
union
{
select ?key (sum(?npcount) as ?value) where {
bind("acceptedNpCount" as ?key)
optional { <x:> <x:> ?_userid_iri } # ensure grlc is picking up the placeholder
values ?npType {
<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub>
<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub>
<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub>
}
bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service)
service ?service { select (count(distinct ?np) as ?npcount) where { optional {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np np:hasPublicationInfo ?i .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
{ {
graph ?i { ?np pav:authoredBy ?_userid_iri . }
} union {
graph ?i {
?np bibo:authorList ?authorList .
?authorList ?hasElement ?_userid_iri .
filter(strstarts(str(?hasElement), str(rdf:_)))
}
} }
} }
group by ?np
} }
group by ?key
}
}
order by ?key
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-user-stats-from-userid
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
|||
|
links a nanopublication to its pubinfo
http://www.nanopub.org/nschema#hasPublicationInfo
pubinfo
|
get-user-stats-from-userid
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|