[rt-users] Tickets based on custom field value

[Mathew Snyder]

Also, does the FromSQL method support all SQL statements to include joins?

Mathew

Mathew Snyder wrote:
> 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
>>>
>>
> _______________________________________________
> 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
>