Confluence has been updated to version 6.15.9

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


Introduction



The sandwich order is an example where orders can be entered, using a list of possible menu choices.


Screenshots



Grid configuration


gd.columns=line, sandwich, requester,number
gd.table=sandwichOrder

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


col.line=Line
col.line.type=sequence
col.line.sequencePrefix=LINE-
col.line.width=50

col.sandwich=What sandwich
col.sandwich.type=list
col.sandwich.query=select name from sandwich_menu order by name
col.sandwich.query.ds=gridds
col.sandwich.required=true
col.sandwich.width=200
col.sandwich.autocomplete=false

col.requester=For whom
col.requester.type=string

col.number=Count
col.number.type=integer


SQL Setup


Use following sql to create a table and populate the sandwich menu table.


-
-- Table structure for table `sandwich_menu`
--

DROP TABLE IF EXISTS `sandwich_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sandwich_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) DEFAULT NULL,
  `Price` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sandwich_menu`
--

LOCK TABLES `sandwich_menu` WRITE;
/*!40000 ALTER TABLE `sandwich_menu` DISABLE KEYS */;
INSERT INTO `sandwich_menu` VALUES (1,'Lemon pepper chicken',1.95),(2,'Chicken tikka with minted mayo',1.95),(3,'Chicken and bacon',1.95),(4,'Cajun chicken',1.95),(5,'Chinese chicken',1.95),(6,'BBQ chicken',1.95),(7,'Mexican chicken',1.95),(8,'Tuna mayo',1.65),(9,'Tuna crunch',1.85),(10,'Egg mayo',1.5),(11,'Egg mayo & crispy bacon',1.95),(12,'Prawn & marie rose sauce',2.2),(13,'Cheese',1.3),(14,'Cheese mix',1.6),(15,'Ham',1.8),(16,'Beef',1.8),(17,'Corned beef',1.8),(18,'Turkey',1.8);
/*!40000 ALTER TABLE `sandwich_menu` ENABLE KEYS */;
UNLOCK TABLES;


See also


//

  • No labels