10 Newest Unowned tickets i'm allowed to see

Hello list,

After some initial confusion, i realized that a user’s "10 latest"
block gets the 10 latest tickets, and THEN filters it for what queues
that user is allowed to see - sometimes resulting in 4 tickets, or 1
ticket, or no tickets at all!

I’m not sure how, or if i can, change this behaviour. I’d like the 10
most recent to show 10 tickets at all times - for
permissions-filtering to occur before the 10 most recent are counted.
Any ideas?

/chown -R us:us /yourbase

Hello list,

After some initial confusion, i realized that a user’s “10 latest”
block gets the 10 latest tickets, and THEN filters it for what queues
that user is allowed to see - sometimes resulting in 4 tickets, or 1
ticket, or no tickets at all!

I’m not sure how, or if i can, change this behaviour. I’d like the 10
most recent to show 10 tickets at all times - for
permissions-filtering to occur before the 10 most recent are counted.
Any ideas?

Depending on your RT version, you can try the following option:

Set($UseSQLForACLChecks, 1);

but read comment on it in RT_Config.pm before enabling it.

Depending on your RT version, you can try the following option:

Set($UseSQLForACLChecks, 1);

but read comment on it in RT_Config.pm before enabling it.

Go not to the docs for counsel, for they will say both no and yes.
“In some cases it result in performance improvements, but some setups
can not handle it.”
Is this hardware- or memory-dependent? What are the variables in
whether it improves or degrades…?

At any rate, trying it now, as this sys isn’t in production yet.
Thanks for the pointer, i saw that option but i didn’t understand what
it meant at the time.

/chown -R us:us /yourbase

Depending on your RT version, you can try the following option:

Set($UseSQLForACLChecks, 1);

but read comment on it in RT_Config.pm before enabling it.

Go not to the docs for counsel, for they will say both no and yes.
“In some cases it result in performance improvements, but some setups
can not handle it.”
Is this hardware- or memory-dependent? What are the variables in
whether it improves or degrades…?

At any rate, trying it now, as this sys isn’t in production yet.
Thanks for the pointer, i saw that option but i didn’t understand what
it meant at the time.

I suspect that with certain backends or SearchBuilder versions, the
DB plans could be umm… non-optimal for this feature. :slight_smile: I am trying
it here as well.

Cheers,
Ken

I suspect that with certain backends or SearchBuilder versions, the
DB plans could be umm… non-optimal for this feature. :slight_smile: I am trying
it here as well.

Indeed. It’s still largely experimental. I’d always been fairly certain
that it was “impossible”, but Ruslan worked a whole bunch of magic.
Feedback would be hugely appreciated.

DB and setup dependent. ACL checks in RT are painful for all DBs,
however these days we at least know how to cook old queries and there
are a lot of knowledge on the web. This new feature changes balance.
New queries may need new indexes, new execution paths may need new
optimizations and bug fixes and…On Thu, Feb 5, 2009 at 6:59 PM, Rob Munsch rob.munsch@gmail.com wrote:

On Thu, Feb 5, 2009 at 8:15 AM, Emmanuel Lacour elacour@easter-eggs.com wrote:

Depending on your RT version, you can try the following option:

Set($UseSQLForACLChecks, 1);

but read comment on it in RT_Config.pm before enabling it.

Go not to the docs for counsel, for they will say both no and yes.
“In some cases it result in performance improvements, but some setups
can not handle it.”
Is this hardware- or memory-dependent? What are the variables in
whether it improves or degrades…?

At any rate, trying it now, as this sys isn’t in production yet.
Thanks for the pointer, i saw that option but i didn’t understand what
it meant at the time.


/chown -R us:us /yourbase


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.