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

[Pete Nellmapius]

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

[Kateryna Grynko]

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...

[Pete Nellmapius]

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"

[Maryna Brodina]

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