It would help even more to show the original “RT query” that generated
this SQL.
Eric Schultz
United Online
It would help even more to show the original “RT query” that generated
this SQL.
Here you go.
Thanks,
Brian
[13/Jul/2006:10:09:30 -0400] x.x.x.x SSLv3 RC4-MD5 “GET
/Search/Results.html?Order=ASC&Query=%20Priority%20%3D%2075%20AND%20Created%20%3E%20’1%2F1%2F2006’%20AND%20Queue%20%3D%20’alerts’%20AND%20’CF.%7BActionable%7D’%20LIKE%20’Yes’%20AND%20’CF.%7BIR%7D’%20LIKE%20’Yes’%20AND%20Content%20NOT%20LIKE%20’Incident%20Report’&Rows=&OrderBy=id&Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’
HTTP/1.1” 52331