Can't change the selected queues for an Agent's my queues

[hawkinspeter]

I've upgraded to 3.1.3 (with ITSM) with an oracle backend and it's been working fine so far. However, when we tried to amend an Agent's selection of queues in their My Queues, it seems to work, except it doesn't save the changes.

I'm quite happy to manually alter the sql if necessary to update the couple of agents that need to be updated, but I couldn't fine where the "My Queues" are stored. Anyone know?

[yuri0001]

Hi!
Try to see "personal_queues" table

[jojo]

Thats a known (and it in upcomming version fixed) bug: - 2012-04-05 Fixed bug#8368 - Personal Queues update is not reflected in UI.

[hawkinspeter]

Thanks - I've had a look and run a quick bit of sql:

insert into personal_queues (USER_ID, QUEUE_ID)
(select 21, ID from queue
where NAME not like 'Development%'
minus
select USER_ID, QUEUE_ID from personal_queues);

Unfortunately, it's not updating the list in "My Queues" when I edit the preferences for my agent.

I've now done a test and it looks like emails get sent correctly according to the values in personal_queues, but the multi-select box in agent preferences does not update correctly. It must be being cached somewhere.

[hawkinspeter]

Just seen the post about the fixed bug on this. Maybe I should have checked the bug tracker first, but I've had trouble searching as the terms "Agent" and "My Queues" are very common.