Show values from other joomla table (author details)

Hello,

I have a website (a research journal) where one content item has multiple authors. I have realised this as a joomla plugin. The values are saved in a joomla table "#__authors" with article_id and user_id (=com_comprofiler id).

Now I want to show in the user profile all articles (table #__authors where user_id = profiler_id). I would know how to do this in joomla but I don't know where to start in com_comprofiler. do I need a new plugin? is there a similar one (like user items?) that I could adapt?

I want to show the following
User 1
Author of Article XY, Article AB

User 2
Author of Article AB

User 3
Author of Article AB, Article KL

Thanks for any hints!
Seagul

You can query values from other tables using CB Query Field, but I don't know how well it's going to fit your needs. You'll probably need a custom developed plugin to handle the display or at least a new model for CB Articles to handle an article having multiple authors.