Forum | Appery.io

Posted: **Mon Sep 30, 2013 1:19 pm**

I have a collection with columns A,B,C all Strings;
Q1) I want to select more than 1 column Distinctly.
Q2) I want want to Select where using more than 1 criteria eg: Column A = "AValue" and B = "BValue"
All the columns are Strings
How do I construct the Distinct and Where Clauses

Posted: **Mon Sep 30, 2013 1:57 pm**

Hi Pete,

Here is an example: code{"myparam1":{"$gte":"1", "$lt":"2"},"myparam2":{"$gte":"3", "$lt":"4"}}/code
You can read more here: http://docs.appery.io/documentation/b...

Posted: **Mon Sep 30, 2013 2:45 pm**

Thanks. The 'where' works great.
I'm having a problem with the distinct parameter.
In SQL it would be "Select a, b, distinct From Table1"

Posted: **Mon Sep 30, 2013 3:33 pm**

Hello! Please take a look here http://docs.appery.io/documentation/b...

Forum | Appery.io

Rest Services Select with where having multiple Criteria and Select Distinct using multiple Columns

Rest Services Select with where having multiple Criteria and Select Distinct using multiple Columns

Rest Services Select with where having multiple Criteria and Select Distinct using multiple Columns

Rest Services Select with where having multiple Criteria and Select Distinct using multiple Columns

Rest Services Select with where having multiple Criteria and Select Distinct using multiple Columns