OwnerGroup = x OR OwnerGroup = y never returns


#1

Hi RT users,

I had a user generate a search for all the tickets owned by the members of two groups, i.e. OwnerGroup = ‘group1’ OR OwnerGroup = ‘group2’. Both of the groups have a small number of users and the individual group checks return quickly. When the 2 groups are searched at the same time, the query kept running until I killed it. However, using an explicit 'Owner = ‘a’ OR Owner = ‘b’ … for all of the members in the 2 groups, the query completes as expected. Is there something wrong with how this is handled?

Regards,
Ken


#2

Hi,

Just an update. This is due to the DB (PostgreSQL) needing to generate a very large join. Is there anyway to have the search use a UNION of the 2 pieces instead of the OR condition? That executes very quickly. For now, I have simply told our users to not use that construct.

Regards,
Ken