vivodashboard
vivodashboard copied to clipboard
Sometimes first-last author position not being updated in field_author_position_value
This author position is blank for this export but it should say first author.

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.