Database search

[Gurinder Mann]

Two dropdown button and search button to display results.
Hi I am trying to create a search feature where users select two separate inputs from the drop down buttons and then click the search button to display the results in a "list" screen. I am not sure how to proceed with this. Please help me.

Example:

{Select State} Present in DB

{Select City} Present in DB

{Search Button}

{Show Relate Info in a list}

These have input component and not the two drop down components that I wish to use for my search. I have a database that would display results based on what user selects from the two drop downs and clicking the search button. The results then would be displayed on the list component.

Hi I have used this js for my "before sens": return '{"state":"'+value+'"}'; But when I try to map my city too the same where clause it doesn't work... Do I have to create second where clause??? Please help

And don't mark it answered when it is not

[Gurinder Mann]

I have used this js: return '{"state":"'+value+'" , "city":"'+value+'" }';

And mapped both the dropdowns to the "where" in the query for "before send". It still doesn't work??

[Serhii Kulibaba]

Hello,

Do you use that JS on the "where" parameter? Could you send us screenshots with request and response data from the browser's network tab?

[Gurinder Mann]

Attached are the pictures for before send and sucess events

[Gurinder Mann]

Attached are the before send and success event pictures

[Nick Pitt]

I've got the same problem. Built loads of query services with no problem. Getting this message off of the list service for the collection.

{
"status":400,
"uri":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"DBSQ960",
"description":"Specified brand is not valid"
}
}

[Nick Pitt]

Refer to this problem i have raised here https://getsatisfaction.com/apperyio/...

This may also help you Gurinder.

[Serhii Kulibaba]

Please use $and parameter for complex queries: https://devcenter.appery.io/documenta...