robotoworks / mechanoid

Eclipse plugin providing a set of DSL's for the rapid development of Android apps
58 stars 26 forks source link

SQL MIN() Function in Mechanoid DB and raw query #233

Open mrjbg opened 10 years ago

mrjbg commented 10 years ago

Hi,

is it possible to do the following in code in Mechanoid DB through the API? SELECT MIN(column_name) FROM table_name;

What about raw queries?

Thanks!

fluxtah commented 10 years ago

It should be possible to use the function in your column projection, ie:-

    String cols= new String[] {"min(column_name) as alias_name"};

At the most there is no way to use a raw query out-of-the-box but its something I am looking at.

On 19 Apr 2014 16:17, mrjbg notifications@github.com wrote:

Hi,

is it possible to do the following in code in Mechanoid DB through the API? SELECT MIN(column_name) FROM table_name;

What about raw queries?

Thanks!

— Reply to this email directly or view it on GitHub.