vivodashboard icon indicating copy to clipboard operation
vivodashboard copied to clipboard

Sometimes first-last author position not being updated in field_author_position_value

Open paulalbert1 opened this issue 6 years ago • 0 comments

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.

paulalbert1 avatar Sep 12 '18 13:09 paulalbert1