Searching in two or more fields

Yeah I've been thinking about this too. It will be a more costly operation with multiple fields to search, but there is no reason I should prevent it by design.

I agree. The ability to search in more than one CCK field would be fantastic. This is a great module and thanks for your hard work danielb.

Hmm I did some work on this and it turns out if you allow multiple fields to be searched you are stuck with extra processing whether you use the option or not. So I will extract this functionality and implement it in a seperate module.

That'd be awesome.

Hmm I'm still not sure how to go about this, but I will consider it in the Finder module.

I just figured out how I'm going to do this, I'm excited, but there's a bit of work to do...

I would like to see this feature too. if you need any help with coding or if you need ideas how to solve this, feel free to contact me.

basically you just need to find a way to easily build the SQL-Query by Joining the tables together and extending the
'WHERE' part, just like Views it does.
Maybe there are already code-pieces in Views that solves exactly your problem!

Well that's not really the problem, finder can already query multiple fields with one query either using it's own query builder or the views API, but if you've only got one form field to put that data into - what exactly do you do? I think this part of it will be a bit inefficient whether we like it or not, because there will need to be another check of the returned fields to see which one met the matching criteria.
Is there SQL for "only select the field that meets it's 'where' condition"? If there is I don't know about it.

Just an update, I have spent some time implementing this but I keep running into problem after problem, I can't guarantee I'll deliver on this, but I'm having a go.

subscribing here.

subscribing.

Subscribing. Important issue I think.

I have got this working for autocompletes and nodes on my copy, more work has to be done to get it working for users/views/optionwidgets and even the results page. But at least now I have bits and pieces of code to handle the extra functionality that I can use to do the rest.

Might also need to redesign the queries to use aliases now that it may be possible to pick two fields from different tables with the same name and blow the whole thing up.

Anyways this is why I'm not really solving the other issues atm.

subscribe

I need this to use this very good module. :)

looks to be working, I'll put it up as a DEV version as there may be some kinks to iron out yet

Hello, I just updated to the dev. version of today in order to search in two or more fields.

I'm using the view finder type and my view is set to use 4 nodes type.

After searching something, I've got this in a popup of ma navigator:

Une erreur s'est produite. 
http://fra.pariscine.com/finder_autocomplete/autocomplete/1/1
<br />
<b>Fatal error</b>:  Cannot use object of type stdClass as array in <b>/home/pariscin/www/sites/all/modules/finder/modules/finder_autocomplete/finder_autocomplete.module</b> on line <b>280</b><br />

in the results page, i've got:

warning: Invalid argument supplied for foreach() in /home/pariscin/www/sites/all/modules/finder/modules/finder_views/finder_views.module on line 331.

I have this errors even if I'm using Finder with only one field.

please start a new issue if you find anything i've missed

Here the new issue #571510: Errors with 8 Sept dev version with new feature: Searching in two or more fields :)