Hey there,
I have an table called "projects" and a business process flow "projectphase" which we use to determine the current tender status (Lead, Identify or Quote).
I am trying to list all rows from the "projects" table which are currently in the "quote" projectphase and display the information in an HTML table.
I can't find a way to do this. Basically, I am able to list all rows from the "projectphase" table which contain a certain activestageid_value. When I create an HTML table, I am able to display the names of projects in the "Quote"-Projectphase. I'm unable to fetch more information tho because the projectid is the only informationen referenced in the "projectphase" table.
Is there a way to use these fetched projectids (for example 6 in Total) to list rows of within the project table to retrieve more information about the projects?
Kind regards
Just