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.

Table Grid Editor (legacy) Documentation

Family List

Analytics

Introduction

Screenshots

Grid configuration

SQL Setup

Related content