With reference to old topic : https://www.cuba-platform.com/discuss/t/display-two-tables-table-1assigned-authors-and-table-2-unassigned-authors.
Two Tables : Assigned Authors (authorsbyPapersDs) and Unassigned Authors (authorsDs). Authors can be assigned to ScientificPaper (ScientificPaperDs) and can also be unassigned.
My Question is :
On Table (Assigned Authors). I would like to display list of ScientificPapers (other ScientificPapers) that belong to that Assigned Author in a row using generatecolumn.
I can use Popup Button to display the list of Paper belonging to Author (Example Assigned Author) and use addaction to perform action (like opening that paper by id).
The issue is : Table 1 needs 3 collection Datasource. authorsByPaperDs, authorsDs and scientificPapersDs.
All 3 datasources are linked by One to Many Relationship. Author can have multiple Papers. Assigned Author can have multiple papers. ScientificPapers can have multiple Assigned Authors.
I believe this can be achieved using DataManager.
Some sample implementation or idea for adding a generatedcolumn to AssignedAuthor Table which shows list of all Scientific Papers belonging to each Assigned Author in a row using DataManager will be helpful.
I am aware of the method for generating a column and adding an action.
I am not aware on how to add the list (Assigned Author with list of ScientificPapers) using DataManager to the new column of Assigned Author Table.
Thanks for your guidance.