I have an app with a One to many relationship and then a many to many relationship and I’m struggling with it!
Specifically i have the following relationships:
User to Projects (this is one to many - a project belongs to only one user, but a user can have multiple projects)
Projects to Skills (this is a many to many relationship - a product can have multiple skills, and a skill can belong to multiple projects)
What I’m trying to do is be able to show a user’s projects and associated skills. I am able to do this in a screen with a list within a list (see pic below) but then when I try to use the pdfgeneratorapi component, in the magic text I can access the ‘current project’ for a user’ but then not the ‘current skills’ for that project, only the count.
I have seen similar posts to this, but none that solve this particular problem. If anyone could help that would be much appreciated!
I want to display the skills by project. I seem to be able to do this in a list, but I’m trying to iterate through using the pdf API component and it won’t let me add skills in the magic text. As per screenshots
I think you should select the skills collection and filter it for current project >skills but the current project data should be available in the screen. How you come to the screen where this component located?