[rt-users] WHERE clause when using LimitXXX

[Jesse]

The WHERE Clause is generated by DBIx::SearchBuilder... It isn't as flexible
as hand-hacking raw sequel. this may or may not be a win.  Over time
it's been getting more and more flexible and will continue to do so.
at some point, dropping in raw SQL clauses should certainly be doable.

I can't fully divine what your usage scenario is, but 

Limiting to (Status = 'new' OR Status = 'open') AND (Owner = '2' or Owner = $RT::Nobody->Id) may be what you want.  If not, can you describe in english
what you're trying to query for?

        -j
On Wed, Aug 01, 2001 at 12:56:10PM +0800, Rafael Corvalan wrote:
> Hi,
> How is the WHERE clause constructed when we call $Tickets->LimitXXXX?
> I know it depends on the field type, so if the field type is a date (for example LimitDate method) then "AND" is used. But this ENTRYAGGREGATOR is used between fields of the same type only? And what about fields of different types?
> 
> For example, how can I create the following filters:
> 
> 1) Status="new" OR Owner=2
> Is the following correct?:  $Tickets->LimitStatus("new"); $Tickets->LimitOwner(2);
> 
> or a little more complex (but actually, that's what I want):
> 
> 2) Status="new" OR ( Status="open" AND Owner=2)
> 
> Thanks
> Rafael
> -- 
> 
> _______________________________________________
> FREE Personalized E-mail at Mail.com 
> http://www.mail.com/?sr=signup 
> 
> Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! 
> http://www.net2phone.com/cgi-bin/link.cgi?143 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

that's security the same way that asking for directions to topeka and
being told that a seal is a mammal is informative
					-robin at apocalypse.org