Confluence has been updated to version 6.15.9

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


Introduction

The family list grid is used to collect the names of a family. It shows how to setup a grid with multiple types of columns, storing its data into a mysql database.

Screenshots

Grid configuration

#
# There are 4 columns
#
gd.columns=name, dob, gender, relation, hobbies

gd.tablename=familylist


#
# Family list is stored in the mysql database 'igrid_test' running on the local machine
# The database is accessed using userid igrid_tester and password igrid_tester
# 


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


col.name=First name
col.name.type=string
col.name.width = 40
col.name.editable = true
col.name.sortable = true
col.name.required = true

col.dob=Date of Birth
col.dob.type=date
col.dob.width=30
col.dob.editable=true
col.dob.sortable=true
col.dob.required=true


col.gender=Gender
col.gender.width=30
col.gender.sortable=true
col.gender.type=radio
col.gender.list.size=2
col.gender.name1=Male
col.gender.value1=M
col.gender.name2=Female
col.gender.value2=F

col.relation=Role
col.relation.width=30
col.relation.sortable=true
col.relation.type=list
col.relation.list.size=4
col.relation.name1=Father
col.relation.value1=Dad
col.relation.name2=Mother
col.relation.value2=Mom
col.relation.name3=Son
col.relation.value3=S
col.relation.name4=Daughter
col.relation.value4=D



col.hobbies=Hobbies
col.hobbies.type=textarea
col.hobbies.rows=5
col.hobbies.cols=60


SQL Setup

No special setup required.

  • No labels