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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
