Client GeoDynamics found that different authors were showing in the citation tabs for a resource where the search results of citations of that same scientific journal article showed the right authors.
Summary of the Development
Looking at the SQL statement, with the inner joins of tables 'jos_citations_assoc' and 'jos_citations', the right key should have been given to 'jos_citations_authors' should have been CID - the citation id, and not the table id. With table id of 1445 given, it picked up the related author and used that. But using CID of 1393, it returns nothing for related authors, and will use the string of authors from the citation array object.
All was done in production environment on GeoDynamics because the need for real data.
Reference
Summary of the Issue
Summary of the Development
Testing Strategy
Manually tested working on production GeoDynamics