On 7/23/07, Brian Kerr [EMAIL PROTECTED] wrote:
When doing a search by requestor/owner email address now, we are
getting a nasty query produced. Here are the details of the query.
Let me know if you need any more information.
Requestor.EmailAddress LIKE 'tom' OR Owner = 'tom'
Here is
On 7/25/07, Brian Kerr [EMAIL PROTECTED] wrote:
On 7/23/07, Brian Kerr [EMAIL PROTECTED] wrote:
When doing a search by requestor/owner email address now, we are
getting a nasty query produced. Here are the details of the query.
Let me know if you need any more information.
On 7/24/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:
Here is what the query looks like when formed in the 3.4.5 query
builder. It returns results in less than a second.
But as far as I can see the query below returns wrong results and
that's exactly what we've fixed.
The following query finds
On 7/25/07, Brian Kerr [EMAIL PROTECTED] wrote:
On 7/24/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:
Here is what the query looks like when formed in the 3.4.5 query
builder. It returns results in less than a second.
But as far as I can see the query below returns wrong results and
that's
Hello, Brian.
Ok, I've forgotten about Status field and we're talking only about
Requestor.EmailAddress = tom OR Owner = tom. I think that I've found
problem. Here are three queries I want you to compare. Other user can
do that too, but please replace main.Owner = with some valid
user ID as
On 7/24/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:
Hello, Brian.
Ok, I've forgotten about Status field and we're talking only about
Requestor.EmailAddress = tom OR Owner = tom. I think that I've found
problem. Here are three queries I want you to compare. Other user can
do that too, but
Ruslan,
I tested the last two queries on my PostgreSQL 8.2 database. The
original query was taking so long that I killed it:
On Wed, Jul 25, 2007 at 02:33:58AM +0400, Ruslan Zakirov wrote:
Hello, Brian.
Ok, I've forgotten about Status field and we're talking only about
Requestor.EmailAddress
On 7/23/07, Brian Kerr [EMAIL PROTECTED] wrote:
Hi,
This ticket system has been upgraded from 2.0.12 - 3.4.5 - 3.6.4.
Mysql 4.1.22, Centos 4.4, apache 2.0.52, mod_fastcgi.
When doing a search by requestor/owner email address now, we are
getting a nasty query produced. Here are the details of
On Mon, Jul 23, 2007 at 11:02:10AM -0400, Brian Kerr wrote:
On 7/23/07, Brian Kerr [EMAIL PROTECTED] wrote:
Hi,
This ticket system has been upgraded from 2.0.12 - 3.4.5 - 3.6.4.
Mysql 4.1.22, Centos 4.4, apache 2.0.52, mod_fastcgi.
When doing a search by requestor/owner email address now,
On Mon, Jul 23, 2007 at 04:59:27PM +0100, Nicholas Clark wrote:
mysql SELECT COUNT(DISTINCT main.id) FROM Tickets main CROSS JOIN Users
Users_3 JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND
( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN
10 matches
Mail list logo