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?
-jOn Wed, Aug 01, 2001 at 12:56:10PM +0800, Rafael Corvalan wrote:
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:
- 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):
- Status=“new” OR ( Status=“open” AND Owner=2)
FREE Personalized E-mail at Mail.com
Talk More, Pay Less with Net2Phone Direct®, up to 1500 minutes free!
rt-users mailing list
jesse reed vincent – firstname.lastname@example.org – email@example.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