Answered Searching user extended fields

The first one will always be checked, after that any ANDs will be "anded" with the first one and any ORs will be "orred" with the first one. You can make it more complex, but that will complicate the where statement.

Can you describe what you actually want?

Quote from: BobRay at Oct 09, 2015, 09:18 PM

The first one will always be checked, after that any ANDs will be "anded" with the first one and any ORs will be "orred" with the first one. You can make it more complex, but that will complicate the where statement.

Can you describe what you actually want?

OK thanks, I'd like them to be able to search by 1 or more criteria individually - and also, an option to add criteria together to narrow the search...

I'm afraid I need more to go on. Do you have a user interface created for the search that will let you determine what kind of search it will be? You could post a copy of the form, and a description of what you want to happen based on the submitted results.

Quote from: BobRay at Oct 10, 2015, 03:51 AM

I'm afraid I need more to go on. Do you have a user interface created for the search that will let you determine what kind of search it will be? You could post a copy of the form, and a description of what you want to happen based on the submitted results.

OK thanks Bob. I think, I will just leave it as it is for now - if the client wants to change it later I will update on this forum post. Thanks

I struggled with a similar problem, as much as I like using xPDO, I finally broke down and just created an SQL query string that I used to query the table.

It was much easier to develop since I was able phpMyAdmin to build and test the query string. Once I had a query string that gave me the results I wanted, it was just a matter of writing code to plugin the values being sent by the form.

Quote from: timrca at Nov 15, 2015, 06:42 PM

I struggled with a similar problem, as much as I like using xPDO, I finally broke down and just created an SQL query string that I used to query the table.

It was much easier to develop since I was able phpMyAdmin to build and test the query string. Once I had a query string that gave me the results I wanted, it was just a matter of writing code to plugin the values being sent by the form.

Sounds like an interesting approach - any examples you can share?