Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata


Introduction

The Project Components example shows how you can retrieve information from JIRA in a grid which uses cascading lists.

Screenshots

Grid configuration


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

  • No labels