[SOLVED] All tickets shown in QueueView-Available tickets

Moderator: crythias

Locked
pmontesd
Znuny newbie
Posts: 21
Joined: 24 Nov 2013, 01:29
Znuny Version: 4.0.24
Real Name: Pablo Montesdeoca
Company: Inerza

[SOLVED] All tickets shown in QueueView-Available tickets

Post by pmontesd »

Hello:

I guess the "Available tickets" buttom in QueueView should only list unlocked tickets (from the URL: otrs/index.pl?Action=AgentTicketQueue;QueueID=1;SortBy=Age;OrderBy=Up;View=Small;Filter=Unlocked). However, it shows all tickets, even those locked and assigned to other agents (owner). Therefore, it shows the same tickets as the "All tickets" buttom.

Same days ago, I tested the ViewableLock setting, adding the 'lock' entry, and then I set it back to default (just 'unlock' and 'lock_tmp'), but as I mentioned I see all tickets.

I use OTRS HelpDesk version: 3.3.1
Last edited by pmontesd on 30 Dec 2013, 14:56, edited 1 time in total.
OTRS 3.3.5 - ITSM Bundle 3.3.5 on Centos 6.4 with Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod.
pmontesd
Znuny newbie
Posts: 21
Joined: 24 Nov 2013, 01:29
Znuny Version: 4.0.24
Real Name: Pablo Montesdeoca
Company: Inerza

Re: All tickets shown in QueueView-Available tickets

Post by pmontesd »

Maybe my assumption is wrong. If so, can anybody please explain me what is the use of "Available tickets" in QueueView?

Regards,
OTRS 3.3.5 - ITSM Bundle 3.3.5 on Centos 6.4 with Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: All tickets shown in QueueView-Available tickets

Post by crythias »

By default, Unlocked = unlock

By code Kernel/Modules/AgentTicketQueue.pm:

Code: Select all

        Unlocked => {
            Name   => 'Available tickets',
            Prio   => 1001,
            Search => {
                LockIDs  => \@ViewableLockIDs,
                StateIDs => \@ViewableStateIDs,
                QueueIDs => \@ViewableQueueIDs,
                %Sort,
                Permission => $Permission,
                UserID     => $Self->{UserID},
            },
        },
ViewableLockIDs come from Kernel/System/Lock.pm sub LockViewableLock which appears to be a cache'd entry.

Given that information (and it makes sense, as this shouldn't need to be a constant database call), otrs.DeleteCache.pl might fix the problem for you, especially in light of:
pmontesd wrote:Same days ago, I tested the ViewableLock setting, adding the 'lock' entry
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
pmontesd
Znuny newbie
Posts: 21
Joined: 24 Nov 2013, 01:29
Znuny Version: 4.0.24
Real Name: Pablo Montesdeoca
Company: Inerza

Re: All tickets shown in QueueView-Available tickets

Post by pmontesd »

I deleted the cache and it worked!!!!

Thank you very much.
OTRS 3.3.5 - ITSM Bundle 3.3.5 on Centos 6.4 with Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod.
Locked