Page 1 of 1

Allow custom queries for getDataSetByQuery against in-memory

PostPosted: Mon Jun 30, 2014 10:03 am
by abeermann
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

Re: Allow custom queries for getDataSetByQuery against in-me

PostPosted: Fri Jul 04, 2014 1:07 pm
by Andrei Costescu
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):

Code: Select all
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?

Re: Allow custom queries for getDataSetByQuery against in-me

PostPosted: Fri Jul 04, 2014 5:26 pm
by Andrei Costescu
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.