Finally to run the treeview demo I have added 3 columns in the create command  above

  `level` int(11) NOT NULL,
  `lft` int(11) NOT NULL,
  `rgt` int(11) NOT NULL, 

and inserted the following data test:

INSERT INTO accounts VALUES(1,NULL,'A1'   ,100001,11,12,13,0,1,14);
INSERT INTO accounts VALUES(2,1,   'A11'  ,100011,111,112,113,1,2,3);
INSERT INTO accounts VALUES(3,1,   'A12'  ,100012,121,122,123,1,4,11);
INSERT INTO accounts VALUES(4,1,   'A13'  ,100013,131,132,133,1,12,13);
INSERT INTO accounts VALUES(5,3,   'A121' ,100121,1211,1212,1213,2,5,8);
INSERT INTO accounts VALUES(6,3,   'A122' ,100122,1221,1222,1223,2,9,10);
INSERT INTO accounts VALUES(7,5,   'A1211',101211,12111,12112,12113,3,6,7);

Take a look on the mentioned file to see about them....

It seems miss some columns like "level", "rgt" and "lft" to select sub-tree in the table. These columns are a bit tricky to calculate. Do you have the insert commands or could you point me where I can find them ?

CREATE TABLE IF NOT EXISTS `accounts` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `acc_num` varchar(128) NOT NULL,
  `debit` int(11) NOT NULL,
  `credit` int(11) NOT NULL,
  `balance` int(11) NOT NULL,
  PRIMARY KEY (`account_id`)
) ;

Have you the sql commands to create and populate the table "accounts" ?

This table is needed to run the treeview sample, but the sql is not in the zip jqGrid-3.5.beta-demo.

Thanks,

Congrats for a great grid 🙂

You can look in server.php - case 'tree' :

Regards

Tony

There is posted anywhere the SQL for Tree grid side ?

Currently the downloadable demo does not include the sql for the tree grid, only for normal grid.