Allow custom queries for getDataSetByQuery against in-memory

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Allow custom queries for getDataSetByQuery against in-memory

Postby abeermann » Mon Jun 30, 2014 10:03 am

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
abeermann
 
Posts: 101
Joined: Fri Nov 26, 2010 12:46 pm

Re: Allow custom queries for getDataSetByQuery against in-me

Postby Andrei Costescu » Fri Jul 04, 2014 1:07 pm

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?
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 902
Joined: Tue Jun 26, 2007 3:14 pm

Re: Allow custom queries for getDataSetByQuery against in-me

Postby Andrei Costescu » Fri Jul 04, 2014 5:26 pm

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.
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 902
Joined: Tue Jun 26, 2007 3:14 pm


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 2 guests

cron