Asif
Posts: 0
Joined: Tue Aug 13, 2013 12:56 pm

database query with 'and' operator on multiple fields

Hi,
I want to build search functionality in my app. There are 4 fields on the page :
'first name', 'last name', 'dob' and gender. Now search functionality will be as follows:

any one can search by giving any one of the following fields or the combination of them.
for ex: if he knows the first name and last name then search query will work with combination of these two parameters,
or if he knows first name and dob then search query will work with combination of these two parameters. or if he knows first name, last name and gender then search query will work with these three parameters.

How will i implement this. pls help!!

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

database query with 'and' operator on multiple fields

Hello!

Please take a look here http://docs.appery.io/documentation/b... and here http://docs.appery.io/documentation/b.... If some parameter is not set, replace it with pre.*/prein regexp

Asif
Posts: 0
Joined: Tue Aug 13, 2013 12:56 pm

database query with 'and' operator on multiple fields

Thanks Maryna,
Its working fine

Tavonia Evans
Posts: 0
Joined: Thu Sep 24, 2015 11:19 am

database query with 'and' operator on multiple fields

This is exactly what I need to do, those links on how to don't go to the explanation though, where can I find out how to do this?

Tavonia Evans
Posts: 0
Joined: Thu Sep 24, 2015 11:19 am

database query with 'and' operator on multiple fields

I've done this but $or is causing an internal server error whenever I try to use it... please assist

Return to “Issues”