Home › Forums › TreeGrid › Tree Grid database SQL – demo bug
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.
You can look in server.php – case 'tree' :
Congrats for a great grid 🙂
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.
I think that's it:
CREATE TABLE IF NOT EXISTS accounts (
Thank cristib for your quick reply
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 ?
The create table i sent you is for adjiacent model, not for nested table model.
Take a look on the mentioned file to see about them….
Thanks cristib for your help
Finally to run the treeview demo I have added 3 columns in the create command
Stay connected with us in your favorite flavor!
Copyright 2014 TriRand LtdAll Rights ReservedRSS