Page 1 of 1

Query service with 2 variables

Posted: Thu Aug 01, 2013 3:35 am
by Tim Childs

Hey,

I have set-up a query service to an appery database.

I want to be able to pull out the value of col A where:

col B = local_var and col B = x

I can only seem to map in local variable.

i.e. I can map where col B = local_var, but I do not know how to also map where col B = x

Cheers,
Tim

Image


Query service with 2 variables

Posted: Thu Aug 01, 2013 3:37 am
by Tim Childs

Example is I want to pull the value of column name

WHERE column weight = "heavyweight"

AND column rank = "champion"


Query service with 2 variables

Posted: Thu Aug 01, 2013 4:39 am
by Igor

Hello,

Please take a look at ours docs:
http://docs.appery.io/documentation/a...
http://docs.appery.io/documentation/b...

Let us know if it helps


Query service with 2 variables

Posted: Thu Aug 01, 2013 7:14 pm
by Tim Childs

Hi Igor,

Thanks for replying. I am not really sure where in the interface these curl requests should go?

Cheers,
Tim


Query service with 2 variables

Posted: Thu Aug 01, 2013 8:19 pm
by Kateryna Grynko

Hi Tim,

Please take a look here: https://getsatisfaction.com/apperyio/...


Query service with 2 variables

Posted: Thu Aug 01, 2013 9:01 pm
by Tim Childs

Perfect! Thank you!