Show/Hide column in DBTreeView (dynamically)

Classic Servoy
1

Hi All

Is there a way to show/hide a column of a DBTreeView? I have a binding of an icon column to the DBTreeView and would like to allow the user to hide/show it from within the application. The code in simplified form looks like:

var binding = elements.dbTreeView.createBinding(databaseManager.getDataSourceServerName(controller.getDataSource()), databaseManager.getDataSourceTableName(controller.getDataSource()));
...
binding.setImageMediaDataprovider('icon');
...

Regards, Robert

2

Change the underlying foundset. because the DBtreeview is based on foundset’s, so if you want hide a column, you have to hide/remove the column from the foundset!

3

Thanks Harjo for your solution. It’s exactly what I did. But I thought, there must be a way more elegant solution to it. Like dynamically adding removing the binding of the field. But it doesn’t seem so.

Harjo:
Change the underlying foundset. because the DBtreeview is based on foundset’s, so if you want hide a column, you have to hide/remove the column from the foundset!