[rt-users] Simplifying update history view for tickets?

2016-09-28 Thread Alex Hall
Hello all, The last major complaint, at least for now, that users are giving me is regarding the ticket view. They want to know if I can modify it in a few ways. First, no one wants to see this email-like text, and would much rather it simply be a list of who said what and when. Instead of

Re: [rt-users] Pushing Tickets in queue the "pusher" is not a member of?

2016-09-28 Thread Kenneth Marshall
On Mon, Sep 26, 2016 at 06:02:53PM +0200, Patrick G. Stoesser wrote: > Hello there, > > I'm using RT 4.2.8. I'm having several queues for several departments. > > Now, tickets have to be pushed into other queues where then the > according department works on them. But the "pusher" should not be

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Emmanuel Lacour
Le 28/09/2016 à 11:12, Joel Bergmark a écrit : > Hi! > > This is the output from explain: > > postgres=# EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL > ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN > CachedGroupMembers CachedGroupMembers_2 ON (

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Nilesh
You made some typing mistake, you should get something like this: QUERY PLAN

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Joel Bergmark
Hi! This is the output from explain: postgres=# EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN