Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

On organization profile, add a panel on oldest publications #1054

Open
Daniel-Mietchen opened this issue Feb 22, 2020 · 5 comments
Open

On organization profile, add a panel on oldest publications #1054

Daniel-Mietchen opened this issue Feb 22, 2020 · 5 comments

Comments

@Daniel-Mietchen
Copy link
Collaborator

@Daniel-Mietchen Daniel-Mietchen commented Feb 22, 2020

Similar to the one we already have on topic profiles.

Draft query:

#defaultView:Table
SELECT
  ?publication_date
  ?work ?workLabel
  ?researchers ?researchersUrl
WITH {
  SELECT 
    (MIN(?publication_datetimes) AS ?publication_datetime) ?work 
    (GROUP_CONCAT(DISTINCT ?researcher_label; separator=', ') AS ?researchers)
    (CONCAT("../authors/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?researcher), 32); separator=",")) AS ?researchersUrl)
  WHERE {                                                         
    ?researcher ( wdt:P108 | wdt:P463 | wdt:P1416 ) / wdt:P361* wd:Q131262 .
    ?work wdt:P50 ?researcher .
    ?researcher rdfs:label ?researcher_label . FILTER (LANG(?researcher_label) = 'en')
     {
      ?work wdt:P577 ?publication_datetimes .
    }
  }
  GROUP BY ?work
  ORDER BY ASC(?publication_datetime)
  LIMIT 200  
} AS %results
WHERE {
  INCLUDE %results
  BIND(xsd:date(?publication_datetime) AS ?publication_date)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,nl,ru,zh". }
}
ORDER BY ASC(?publication_date)
 
@Daniel-Mietchen Daniel-Mietchen added this to To do in Authors via automation Feb 22, 2020
@Daniel-Mietchen Daniel-Mietchen added this to To do in Works via automation Feb 22, 2020
@Daniel-Mietchen Daniel-Mietchen added this to To do in Organizations via automation Feb 22, 2020
@mkutmon
Copy link
Collaborator

@mkutmon mkutmon commented Apr 2, 2020

image

@mkutmon mkutmon self-assigned this Apr 2, 2020
@mkutmon
Copy link
Collaborator

@mkutmon mkutmon commented Apr 2, 2020

Something like this?

@mkutmon
Copy link
Collaborator

@mkutmon mkutmon commented Apr 2, 2020

maybe just the oldest 50 works? or do you want to retrieve 200?

@mkutmon
Copy link
Collaborator

@mkutmon mkutmon commented Apr 2, 2020

@Daniel-Mietchen - currently the query just links the researcher to the organization, right? But wouldn't we need to check if the work was actually done at that organization (maybe also check affiliations of the work?)

@Daniel-Mietchen
Copy link
Collaborator Author

@Daniel-Mietchen Daniel-Mietchen commented May 19, 2020

@mkutmon Sorry, hadn't seen your above comments. yes, that looks like a good start. Yes, we currently do not distinguish which link the person has to the organization — doing that would be useful but tricky, since we often simply do not have that data. As for 50 or 200, I think we are usually using 200 for similar queries, but I'd be fine with either, since performance does not play much of a role here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Authors
  
To do
Works
  
To do
Organizations
  
To do
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.