| 1 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'notes.category', '1', '1', 'category', ''); |
|---|
| 2 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'modules.name', '1', '1', 'Module', ''); |
|---|
| 3 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'widgets.type', '2', '1', 'Area', ''); |
|---|
| 4 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'ELT(notes.importance+3,\'6 - Lowest\',\' 5 - Low\',\'4 - Normal\',\"3 - Medium\",\'2 - High\',\'1 - Highest\')', '1', '1', 'Importance', ''); |
|---|
| 5 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'notes.category', '2', '1', 'Category', ''); |
|---|
| 6 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'modules.name', '1', '0', '', ''); |
|---|
| 7 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:7e75af48-6f70-d157-f440-69a8e7f59d38', 'tabs.tabgroup', '1', '1', 'Group', ''); |
|---|
| 8 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'if(menu.parentid=\'\' OR menu.parentid IS NULL,concat( lpad(menu.displayorder,3,\"0\"), \" - \" ,menu.name ) , concat( lpad(parentmenu.displayorder,3,\"0\") , \" - \",parentmenu.name))', '1', '1', '', ''); |
|---|
| 9 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:8d19c73c-42fb-d829-3681-d20b4dbe43b9', 'fromtable.displayname', '1', '1', '', ''); |
|---|
| 10 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'notes.category', '1', '1', '', ''); |
|---|
| 11 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'if(tabledefs.displayname is null,\"global\",tabledefs.displayname)', '1', '1', '', ''); |
|---|
| 12 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'tabledefs.displayname', '1', '1', '', ''); |
|---|
| 13 | INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'if(usersearches.type=\"SCH\",\"Search\",\"Sort\")', '2', '1', '', ''); |
|---|
