Descending TreeGrid Order

[Servant5166]

Hi,

 

How can I sort the TreeGrid in descending order? 

 

I need to show Contract Numbers like (C2017220, C2017210, C2017190) with the latest contract first.

The data use ID and ParentID relationship, for example, ParentID (0220) ID (0221, 0222)

 

Using UniGui 1.0.0.1420

[Sherzod]

Hi,

 

Do you mean sorting the child nodes ?!

[Servant5166]

Hi,

 

Do you mean sorting the child nodes ?!

No,

 

What I would like is to have the ID column to sort in descending order. My customer wants to see the last contract created first in the TreeGrid. 

[Sherzod]

Ok

[Sherzod]

Hi,

 

Can you try this approach for now ?!

 

For example:

 

property:0 -> 0 - ID index

 

UniDBTreeGrid1 -> ClientEvents -> ExtEvents -> Ext.data.TreeStore [store] -> function store.load:

function store.load(sender, node, records, successful, eOpts)
{
    var me=sender;
    me.remoteSort=false;
    me.sort({property:0, direction:"DESC"});
}

Best regards,

[Servant5166]

Hi,

 

Can you try this approach for now ?!

 

For example:

 

property:0 -> 0 - ID index

 

UniDBTreeGrid1 -> ClientEvents -> ExtEvents -> Ext.data.TreeStore [store] -> function store.load:

function store.load(sender, node, records, successful, eOpts)
{
    var me=sender;
    me.remoteSort=false;
    me.sort({property:0, direction:"DESC"});
}

Best regards,

Hi,

 

I can't find the function Ext.data.Treestore you mention. 

 

I using Delphi 10.2

[Sherzod]

Hi,

 

I can't find the function Ext.data.Treestore you mention. 

 

I using Delphi 10.2

 

[Servant5166]

Thanks, you’re the bomb dot com

 

 

Sent from my iPad using Tapatalk

[Servant5166]

storeload.png

Hi,

 

One more question.

Is there a way to move the record pointer to the first record? 

 

When I apply the code you supplied me, it orders the data as expected, but the record pointer is at the bottom of the grid. 

That means the user will have to manually scroll to the top to see the first record.

[Sherzod]

Hi,

 

"I couldn't reproduce this..."

 

Maybe you need this?:

function store.load(sender, node, records, successful, eOpts)
{
    var me=sender;
    me.remoteSort=false;
    me.sort({property:0, direction:"DESC"});
    me.grid.getSelectionModel().select(0);   //<-------------
}

Best regards,

[Servant5166]

Hi,

 

I've attached a screenshot to demonstrate the issue.

 

At the lower right of the graphic, you'll see the DBTreeGrid scrollbar which is at the bottom.

The record at the top of the DBTreeGrid is highlighted because I see the contract number in the status bar.

 

Thanks for your help.

 

 

[Servant5166]

Is there a solution for this?

I need to select the first record after sorting.

[Sherzod]

Hi, 

Can you make a simple testcase for this?!