Page 1 of 1

Multiple Where

Posted: Sun Jan 19, 2014 9:15 pm
by Kieran Keene

Hi,

I am looking to use multiple where conditions. So, where X = Y AND Z=A

How can I do this. My two mappings (attached) work independently, but not together Image


Multiple Where

Posted: Sun Jan 19, 2014 9:21 pm
by maxkatz

Multiple Where

Posted: Sun Jan 19, 2014 9:32 pm
by Kieran Keene

Hi,

Thanks for the doc. I am still not sure how to do this?

Field1 in the form must equal database field X AND field2 in the form must match database column Y.

It seems like the document you sent only covers static values?


Multiple Where

Posted: Mon Jan 20, 2014 1:17 am
by Igor

Hi,

What you need to do is:
Save values from "Type" and "Location" fields to the localStorage variables or JS variables then use them in where clause.

Something like this:
pre
code
var val = localStorage.getItem("FirstName");
return '{"Name":"'+val+'"}';
/code
/pre