[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