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) 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? 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? 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 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"});' + ' }'; Link to comment Share on other sites More sharing options...
Frederick Posted December 12, 2020 Author Share Posted December 12, 2020 Nice! Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now