Mar 11th, 2010, 8:12 PM
Hi John,
Eesh, unfortunately the existing search feature isn't terribly strong, so you're rather out of luck. Searching for blank fields can't be done, because the search tools requires you to enter a search string. All you could really do is create a View for each search that you'd like to do. That would allow you to limit the results in that View to only show results that had empty values for a particular field or fields. Not ideal, but it's at least a workaround.
And searching for exact phrases isn't exactly possible either. :-( The SQL SELECT statement that's generated for the searches wraps the string in "%" characters so that ANY results that have that entire string in it will be returned. You could again try getting around this with Views, but I'm not sure that would work... still, worth a shot.
Providing a better search tool is definitely a priority. Once I finish up work on the translations and I can start getting back to main Form Tools development I'll definitely keep this in mind.
Sorry I couldn't be more help!
- Ben
Eesh, unfortunately the existing search feature isn't terribly strong, so you're rather out of luck. Searching for blank fields can't be done, because the search tools requires you to enter a search string. All you could really do is create a View for each search that you'd like to do. That would allow you to limit the results in that View to only show results that had empty values for a particular field or fields. Not ideal, but it's at least a workaround.
And searching for exact phrases isn't exactly possible either. :-( The SQL SELECT statement that's generated for the searches wraps the string in "%" characters so that ANY results that have that entire string in it will be returned. You could again try getting around this with Views, but I'm not sure that would work... still, worth a shot.
Providing a better search tool is definitely a priority. Once I finish up work on the translations and I can start getting back to main Form Tools development I'll definitely keep this in mind.
Sorry I couldn't be more help!
- Ben