Confluence has been updated to version 6.15.9

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

Introduction



Initialize the grid with a parameterized grid. Parameters are based on customfield values.


Screenshots



Grid configuration - the mysql version


gd.columns=plane_name, plane_origin
gd.table=DependsOnCustom
gd.query=select * from airplane where plane_origin like "%{0}%" and plane_name like "%{1}%"
gd.query.parameters=customfield:10010,customfield:10009
gd.query.ds=gridds

col.plane_name=Name
col.plane_origin=Origin

datasource.names=gridds

ds.gridds.connection.type=mysql
ds.gridds.connection.url=jdbc:mysql://charlie:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false
ds.gridds.connection.username=igrid_tester
ds.gridds.connection.password=igrid_tester


Grid configuration - the postgresql version


The difference between the mysql and the postgresql version, is the gd.query property.


gd.columns=plane_name, plane_origin
gd.table=DependsOnCustom
gd.query=select * from airplane where plane_origin like '%{0}%' and plane_name like '%{1}%'
gd.query.parameters=customfield:10010,customfield:10009
gd.query.ds=gridds


datasource.names=gridds
ds.gridds.connection.type=postgres
ds.gridds.connection.driver_class = org.postgresql.Driver
ds.gridds.connection.url = jdbc:postgresql://localhost:5432/igrid_test
ds.gridds.connection.username = igrid_tester
ds.gridds.connection.password = igrid_tester


col.plane_name=Name
col.plane_name.type=string

col.plane_origin=Origin
col.plane_origin.type=string


Custom field setup


  • customfield:10010
    This custom field is a select list, listing all the plane origins
  • customfield:10009
    Another select list, listing all the plane names.


SQL Setup


--
-- Table structure for table `airplane`
--

DROP TABLE IF EXISTS `airplane`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `airplane` (
  `plane_name` varchar(255) NOT NULL,
  `plane_origin` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `airplane`
--

LOCK TABLES `airplane` WRITE;
/*!40000 ALTER TABLE `airplane` DISABLE KEYS */;
INSERT INTO `airplane` VALUES ('BOEING-737','USA'),('BOEING-343','USA'),('AN-2','USSR'),('AN-12','USSR'),('AIRBUS-A3','EUROPE'),('AIRBUS-A5','EUROPE');
/*!40000 ALTER TABLE `airplane` ENABLE KEYS */;
UNLOCK TABLES;


See also


  • No labels