[rt-users] 3.6.3 - sorting on Custom Fields still not working?

Joop JoopvandeWege at mococo.nl
Wed Feb 14 03:03:56 EST 2007


Joe Casadonte wrote:
> On 2/13/2007 3:14 AM, Joop wrote:
> 
>> Could you post the TicketSQL for your search?
>> You can get this from the QueryBuilder page and than 'Advanced'
> 
> With this data:
> 
> CF1 = Select one text field (One, Two, Three, Four, Five)
> CF2 = numeric
> 
>  #   CF1     CF2
> ===  ======  =====
>  1   Four    0.1
>  2   Two     0.1
>  3   Five    0.1
> 21   Two     23
> 22   One     23
> 41   Three   3
> 42   Five    0
> 55   Two     0.5
> 56   Two     0
I'll try to set this up in my test environment.

> I confirmed that the same query run in SQL*Plus returns the same row 
> order.
It better be the same!

>  Is this the "Ticket SQL" you were looking for:
> 
>  Owner = '86' AND ( Status = 'new' OR Status = 'open')
Almost, what I'm missing is/are the CF's. Maybe its because I don't have 
global CustomFields and you do. I'll try a couple of things in our test RT.

Thanks for the feedback,

Joop



More information about the rt-users mailing list