Frederick Posted December 4, 2020 Share Posted December 4, 2020 I have a PostgreSQL query with an "order by shortcode, code" parameter. When a TUniDBTreeGrid's datasource is set to it, the code order is not followed as the query correctly shows. What could be happening here? -- Frederick (UniGUI Complete - Professional Edition 1.90.0.1539) Quote Link to comment Share on other sites More sharing options...
Frederick Posted December 7, 2020 Author Share Posted December 7, 2020 Is a solution available? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 8, 2020 Share Posted December 8, 2020 On 12/4/2020 at 7:54 PM, Frederick said: I have a PostgreSQL query with an "order by shortcode, code" parameter. When a TUniDBTreeGrid's datasource is set to it, the code order is not followed as the query correctly shows. What could be happening here? Hello, How can we reproduce this issue? Quote Link to comment Share on other sites More sharing options...
Frederick Posted December 8, 2020 Author Share Posted December 8, 2020 I have attached the project files. Thanks. dbtreeexclaim.zip Quote Link to comment Share on other sites More sharing options...
风吹小机机 Posted December 12, 2020 Share Posted December 12, 2020 //设置排序字段 treeMenus.ColumnByName('Serial').Sortable := True; //自动排序JS treeMenus.ClientEvents.ExtEvents.Values['store.load'] := ' function store.load(sender, records, successful, operation, eOpts){' + ' sender.remoteSort = false;' + ' sender.sort({property:' + IntToStr(treeMenus.ColumnByName('Serial').Index) + ',direction:"ASC"});' + ' }'; Quote Link to comment Share on other sites More sharing options...
Frederick Posted December 12, 2020 Author Share Posted December 12, 2020 Nice! Thank you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.