Introduction
Excerpt |
---|
The Project Components example shows how you can retrieve information from JIRA in a grid which uses cascading lists. |
Screenshots
Grid configuration
Code Block |
---|
gd.columns = project , component gd.tablename=BOM_test gd.ds = jira # # List all the projects # col.project=Project col.project.type=list col.project.query=select pname, id from project order by pname col.project.query.ds = jira # # Use the selected project to list the corresponding components # col.component=Component col.component.type=list col.component.query=select cname, id from component where project = {project.id} order by cname col.component.query.ds=jira |
SQL Setup
Not necessary