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

Sometimes first-last author position not being updated in field_author_position_value #40

Open
paulalbert1 opened this issue Sep 12, 2018 · 0 comments

Comments

@paulalbert1
Copy link
Contributor

paulalbert1 commented Sep 12, 2018

This author position is blank for this export but it should say first author.

screen shot 2018-09-12 at 9 58 07 am

If we run this on VIVO Dashboard,

select field_author_rank_value, field_id_value, field_author_position_value, z10.entity_id
from field_data_field_scopus_id z0 
join field_data_endpoints z7 on z7.endpoints_entity_id = z0.entity_id
left join field_data_field_author_position z9 on z9.entity_id = z7.entity_id 
left join field_data_field_author_rank z10 on z10.entity_id = z7.entity_id 
join field_data_endpoints z12 on z12.entity_id = z10.entity_id
join field_data_field_id z13 on z13.entity_id = z12.endpoints_entity_id
where field_author_rank_value = 1 
limit 500

we get this:

field_author_rank_value	field_id_value	field_author_position_value	entity_id
1	chensch	first	757893
1	chensch		777831
1	chensch	first	827251
1	chensch	first	827288
1	chensch		827294
1	chensch		827382
1	chensch	first	844776

We would expect that all these values should list author_rank_value of first.

I'm equally concerned that we're missing author position value for last author.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant