Re: [Slashcode-development] Expanding Slash...searching users

[Shane <sh...@lo...>]

On Nov 19, 2003, at 3:10 PM, Christopher Winn wrote:

> Hi,
>
> I've been playing around with Slash::Search lately.  I'm trying to  
> compile some data into a template that effectively says, "Here are all  
> the users who have a maxcommentsize of 1048." For example.  Or, "Here  
> are all the users who have entered a nickname in their preferences."   
> And then spew out that list.
>
> However, I'm having trouble calling the correct search call.  Is there  
> a way to specifically search for all the users who have, for example,  
> selected that they live in California? (an option which of course was  
> added into users_param)..
>

Take a look at

http://cvs.slashcode.com/cgi-bin/cvsweb/slash/plugins/Search/Search.pm? 
rev=1.61&content-type=text/x-cvsweb-markup

sub findUsers

It only searchs against the users table:

my $tables = 'users';

So you'd have to add a join on users_param (that table name might not  
be right) inorder to get the behavior you want.

  Shane