Allow custom queries for getDataSetByQuery against in-memory

Classic Servoy
1

Hello
Currently it is not possible to use getDataSetByQuery with custom queries against in-memory datasources.
Only the querybuilder is supported. Can this be added please?

Best regards
Albert

2

It should already work. What exactly are you trying that doesn’t work? For example such code works (took something from jsunit tests that pass):

var ds = databaseManager.getDataSetByQuery('inMemory_test_DB','select name, gender from person', null, -1)

A sample solution could help show the problem. What version of Servoy did you try it with?

3

I thought you are talking about design-time defined DB Servers that connect to an “In memory” HSQL jdbc database.
But you were taking about “databaseManager.createDataSourceByQuery” I guess.

There’s also a case created for this: SVY-6779.