foundset filter on views

Classic Servoy
1

Hi all,

Scenario:
I’m into the programs managment form (CTRL+1),
I’ve a program in wich I’ve put a form based on a view instead of a table.

I see that I can’t create a foundset filter based on a view.
When I open the combobox, I can choose only beetween the server’s tables.

Can this feature be implemented?

Thanks

Riccardo

2

I don’t have views here. But could you test if it would work if you replace the global method ‘svy_nav_initTableVL’ with:

/**
 * @param {String} _serverName
 *
 * @properties={typeid:24,uuid:"27EF1625-36FD-4420-873A-7E7B27EE6E72"}
 */
function svy_nav_initTableVL(_serverName) {
	if (_serverName) {
		var _tables = databaseManager.getTableNames(_serverName);
		var _views = databaseManager.getViewNames(_serverName);
		_tables.concat(_views)
		_tables.sort()
		application.setValueListItems('nav_table_names', _tables)

	} else {
		application.setValueListItems('nav_table_names', null)
	}
}
3

Ok Sanneke, it works. I’ve deleted my previus reply by mistake.

I’ve modified just a thing:
" _tables = _tables.concat(_views)"

/**
* @param {String} _serverName
*
* @properties={typeid:24,uuid:"27EF1625-36FD-4420-873A-7E7B27EE6E72"}
*/
function svy_nav_initTableVL(_serverName) {
   if (_serverName) {
      var _tables = databaseManager.getTableNames(_serverName);
      var _views = databaseManager.getViewNames(_serverName);
      _tables = _tables.concat(_views)
      _tables.sort()
      application.setValueListItems('nav_table_names', _tables)

   } else {
      application.setValueListItems('nav_table_names', null)
   }
}

However with this code, I see rightly the view’s list and the filter is correctly applied.

Thanks

Riccardo

4

Ok, I will fix that. It will be in the next release.