+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Feature Suggestions (https://forums.formtools.org/forumdisplay.php?fid=7)
+--- Thread: Advanced or Multiple Search (/showthread.php?tid=91)
Advanced or Multiple Search - harmony - Mar 27th, 2009
Does anyone know how easy it would be to add a custom search option to the API so that users could search by more than one criteria?
Example: Search by field 1 and field 2 but not field 5
or: search by field 1 or field 2
or: search by field 1 and field 2 and field 3 (every field in the form)
etc?
RE: Advanced or Multiple Search - Ben - Mar 30th, 2009
Hey Harmony,
This is a great idea. It's definitely do-able, but it would still take a couple of hours to puzzle through.
The ft_api_show_submissions function which lists submissions from the FT database currently allows a number of different option parameters; it would just be a matter of adding a search option to allow for this.
But I'm afraid it's going to have to wait! I have a lot of other stuff to focus on first.
Sorry, Harmony. Bug me about this again sometime in the future.
- Ben
RE: Advanced or Multiple Search - harmony - Mar 30th, 2009
Thanks very much for the reply Ben! You guys are amazing!
RE: Advanced or Multiple Search - ggaffield - Feb 9th, 2015
(Mar 30th, 2009, 10:45 AM)Ben Wrote: Hey Harmony,
This is a great idea. It's definitely do-able, but it would still take a couple of hours to puzzle through.
The ft_api_show_submissions function which lists submissions from the FT database currently allows a number of different option parameters; it would just be a matter of adding a search option to allow for this.
But I'm afraid it's going to have to wait! I have a lot of other stuff to focus on first.
Sorry, Harmony. Bug me about this again sometime in the future.
- Ben
I sure could use this kind functionality. I'm currently rolling this out to my users, and it's the first thing they noticed and said was going to be a problem.
Not only would they need to able to say Field A contains "X" AND Field B contains "Y". They would also like to specify value ranges. equal to, less than, greater than, between.
-Glenn
RE: Advanced or Multiple Search - haneeya - Mar 23rd, 2015
I'd like to see a date filter option for the standard view filter. I would like to filter out results with entires that are prior to current date.
RE: Advanced or Multiple Search - nelsondcosta - Dec 24th, 2017
Any news?
RE: Advanced or Multiple Search - weems085 - Dec 30th, 2017
I would like to filter out results with entires that are prior to current date.
RE: Advanced or Multiple Search - nelsondcosta - Jan 2nd, 2018
Maybe FT4 can hold this feature
