[rt-users] Tickets based on custom field value

[Mathew Snyder]

Does the FromSQL method work for all object types or just tickets?

Mathew

Ruslan Zakirov wrote:
> Easier way is to use FromSQL method and pass a string that has all
> conditions you need, something like:
> $tickets->FromSQL("(Status = 'open' OR Status = 'resolved') AND
> 'CF.{MyCF}' = 'qwe'").
> 
> On 3/8/07, Mathew Snyder <theillien at yahoo.com> wrote:
>> When building an object is it possible to use the same attribute
>> twice?  For
>> instance is this valid:
>>
>> $tickets->LimitStatus(
>>                         VALUE       => 'open',
>>                         VALUE       => 'resolved'
>>         );
>>
>> Or do I need to create two objects with different attributes?
>>
>> Mathew
>>
>> Mathew Snyder wrote:
>> > How do I pull a list of tickets which are labeled with a specific
>> custom field
>> > value.  I see in Tickets_Overlay that there is a LimitCustomField
>> but that looks
>> > like it looks for tickets labeled with a custom field and not
>> necessarily a
>> > specific value within the custom field.  Is this correct or will
>> this do what I
>> > need?
>> >
>> > Mathew
>> > _______________________________________________
>> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>> >
>> > Community help: http://wiki.bestpractical.com
>> > Commercial support: sales at bestpractical.com
>> >
>> >
>> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> > Buy a copy at http://rtbook.bestpractical.com
>> >
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
> 
>