Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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