Getting the sort order of a DBTreeView

Classic Servoy
1

Hi All

I would like to get the sort order of the DBTreeView bean. Ccan I access that sort order somehow? The reason is I would like to display the rows in table view in the same order as displayed in the tree.
Is someone using a SQL statement to accomplish that and willing to share?

Best regards, Robert

2

Hi Robert,

the sort order of the ‘Main nodes’ is just the sort order of those records in the foundset.
The sort order of the subnodes is basically determined by the ‘sort’ dataprovider.

If you don’t use the child’s sort dataprovider, I’d recommend you do so and you will know exactly what your sortorder should be…

Hope this helps

3

Hi Marc

I’m not sure if understand you. I can set the sort order in DBTreeView, with something like:

bind.setChildSortDataprovider('_sort_order'); // Sort childs alphabetically

_sort_order is a calculation with the content ‘name asc’, so doesn’t help at all.

But I would like to get the current sort order used in the DBTreeView, so I need a method like elements.dbTreeView.getChildSortOrder() giving me an array of the sort order of the DBTreeView bean.

Regards, Robert

mboegem:
Hi Robert,

the sort order of the ‘Main nodes’ is just the sort order of those records in the foundset.
The sort order of the subnodes is basically determined by the ‘sort’ dataprovider.

If you don’t use the child’s sort dataprovider, I’d recommend you do so and you will know exactly what your sortorder should be…

Hope this helps

4

hi Robert,
what if you read the child sort dataprovider value ?

regards,
Gabi

5

Hello Gabi

That’s no help, as it is always ’ name asc’ in my case, it’s a calc.

Or did I missunderstand you?

Regards, Robert

Gabi Boros:
hi Robert,
what if you read the child sort dataprovider value ?

regards,
Gabi

6

but what the sort dataprovider is returning for a specific node, is actually the children’s sort order
the dbtreeview does not sort anything if it is not set by the user, this is why I don’t understand what sort
string do you want to request from the bean

regards,
Gabi

7

Robert Huber:
That’s no help, as it is always ’ name asc’ in my case, it’s a calc.

Or did I missunderstand you?

So your child records are sorted by name… then you can do a query (probably union select) on this table which:
a) finds all your parent nodes
b) finds all your child nodes
both based on the pk’s of the foundset of the form on which the DBtreeview is based

your a & b sql should return 1 column which holds the pk, the second column which holds the pk for part a, the parent_id + name column(in 1 column) for part b

This will result in a dataset, which you can sort on col 2.

Then load this onto the form you want to have the dataset on…

The sql would be something like this:

select k_pk_id, k_pk_id from dbtreeview_table where ........
union
select k_pk_id, k_parent_id_parent + name from dbtreeview_table where ........
8

Hi Marc

I tried your SQL stmt but I am stuck (may be at the where clause, I’m not sure).

The table content (reduced to the important columns) looks like this. The table name is school_units. The id column is the pk, the school_unit_id is the foreign key (pointing to the parent node) and name is the column I’d like to sort - under consideration of the tree structure of course. id = 1 is the root of the tree, the entries with school_unit_id = 1 are nodes and the ones with 3 or 5 are the leafes.

id, school_unit_id, name
1, null, ‘Kantonsschule Schaffhausen’
3, 1, ‘Maturitätsschule’
5, 1, ‘Diplommittelschule’
6, 3, ‘Ausbildungsprofil M’
8, 3, ‘Ausbildungsprofil N’
9, 3, ‘Ausbildungsprofil S’
15, 1, ‘Primarschulseminar’
16, 1, ‘Kindergartenseminar’
17, 5, ‘Nur für Anmeldung’
18, 1, ‘Quereinsteiger’
19, 1, ‘Fachmittelschule’

How would your stmt look like for this situation?

Thanks, Robert