Need valid SortBy (TicketFreeTime1)!

Moderator: crythias

Locked
ssanna
Znuny newbie
Posts: 18
Joined: 10 Apr 2013, 14:26
Znuny Version: 3.2.5
Real Name: Stefano Sanna
Company: Ounet Sistemi s.r.l.

Need valid SortBy (TicketFreeTime1)!

Post by ssanna »

Hello, i need to sort the ticket by FreeTime1 but when i put this value (default) i see only blank page and in the system log i've many error like this: "error OTRS-CGI-10 Need valid SortBy TicketFreeTime1)!"
What i can check? Thanks.
ssanna
Znuny newbie
Posts: 18
Joined: 10 Apr 2013, 14:26
Znuny Version: 3.2.5
Real Name: Stefano Sanna
Company: Ounet Sistemi s.r.l.

Re: Need valid SortBy (TicketFreeTime1)!

Post by ssanna »

Can someone help me? Thanks.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Need valid SortBy (TicketFreeTime1)!

Post by crythias »

version of otrs?
Check the field configuration where you're sorting by in sysconfig.
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
ssanna
Znuny newbie
Posts: 18
Joined: 10 Apr 2013, 14:26
Znuny Version: 3.2.5
Real Name: Stefano Sanna
Company: Ounet Sistemi s.r.l.

Re: Need valid SortBy (TicketFreeTime1)!

Post by ssanna »

The version of OTRS is 3.2.5. When i choose the "TicketFreeTime1" in Ticket::Frontend::AgentTicketQueue###SortBy::Default and return on the queue view the queue is empty
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Need valid SortBy (TicketFreeTime1)!

Post by crythias »

I can only assume you've upgraded or didn't fully upgrade successfully. TicketFreeTime1 is not likely to be an available entry unless it's in Dynamic Fields.
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
ssanna
Znuny newbie
Posts: 18
Joined: 10 Apr 2013, 14:26
Znuny Version: 3.2.5
Real Name: Stefano Sanna
Company: Ounet Sistemi s.r.l.

Re: Need valid SortBy (TicketFreeTime1)!

Post by ssanna »

Bad news, there's something that i can do directly on the database?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Need valid SortBy (TicketFreeTime1)!

Post by crythias »

ssanna wrote:When i choose the "TicketFreeTime1" in Ticket::Frontend::AgentTicketQueue###SortBy::Default
The field does not exist. I can't say it much clearer than that.

I don't know that you can sort by a dynamic field. DynamicField_myfield might work, but I can't test/verify.
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
ssanna
Znuny newbie
Posts: 18
Joined: 10 Apr 2013, 14:26
Znuny Version: 3.2.5
Real Name: Stefano Sanna
Company: Ounet Sistemi s.r.l.

Re: Need valid SortBy (TicketFreeTime1)!

Post by ssanna »

I've tried, but there's no an available option.
Locked