Creating a search with 2 variables

[Chris Ross]

Okay, i'm still attempting to setup my database search on my app. I have two variables (county & restaurant). I need the grade to display on another page. I have tried several different ways to setup my backend service, but nothing seems to be working. Please help........

[Chris Ross]

Here's a few pics of my project for school, so you can see my problem

[Chris Ross]

I go into the data screen and try to map the database correctly, but it hasn't worked for me yet. I need some advice

[Chris Ross]

maybe its because I have a javascript, under my buttons, that includes a huge array....... here's an example

[Kateryna Grynko]

Chris, we'll take a look.

[Chris Ross]

I created dynamic buttons for my app. The "restaurant" button will change depending on what "county" you choose.

[Chris Ross]

[Chris Ross]

I need my results to display in the red..........

[Kateryna Grynko]

To create search in Database by 2 fields you would need in request parameter "where" click "Add JS" and paste the following code:codevar whereClause = { "County": localStorage.getItem("County"),
"Restaurant": localStorage.getItem("Restaurant")};
return JSON.stringify(whereClause);/code
You have a typo: column name in database is "County" and localStorage variable name is "County", too.

[Chris Ross]

Thank You!!!!! Can't wait to try it out!!!!!