Variable ticket closed on
Moderator: crythias
Variable ticket closed on
Is there a variable for ticket closed date? I would like to have "closed on" date as one of the columns in search results. I tried using "Closed" as well as "ClosedTime" in Ticket::Frontend::AgentTicketSearch###DefaultColumns under Ticket -> Frontend::Agent::Ticket::ViewSearch but neither work
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Re: Variable ticket closed on
Ticket::Frontend::AgentTicketSearch###SearchCSVData has the variable "Closed". When I export the search results to a CSV, the "closed on" data is exported so it is apparently the correct variable.
However, if I add the variable "Closed" to Ticket::Frontend::AgentTicketSearch###DefaultColumns, I see the column in search results (even with correct translation to German) yet no data in that column.
Just to be clear, I used search filter Status = closed.
Any idea why this behaviour of OTRS?
However, if I add the variable "Closed" to Ticket::Frontend::AgentTicketSearch###DefaultColumns, I see the column in search results (even with correct translation to German) yet no data in that column.
Just to be clear, I used search filter Status = closed.
Any idea why this behaviour of OTRS?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Re: Variable ticket closed on
Any ideas on this one?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Re: Variable ticket closed on
Is there another way of showing ticket closing date in normal search results output?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Variable ticket closed on
The problem is that the closed date is calculated from article_history (last state of type closed) rather than an entry like close_time... at least, that's what it was.
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
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
Re: Variable ticket closed on
Interesting.
Can that value (closed date calculated from article_history) be shown in 'closed' column similar to say the value in the column 'age' which would be a calculated value as well? How?
Can that value (closed date calculated from article_history) be shown in 'closed' column similar to say the value in the column 'age' which would be a calculated value as well? How?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Variable ticket closed on
at least as of 3.x Closed wasn't in the AgentTicketOverviewSmall.dtl
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
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
Re: Variable ticket closed on
At the risk of repeating myself Ticket::Frontend::AgentTicketSearch###SearchCSVData has the variable "Closed" though and the csv file has the relevant date
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Variable ticket closed on
That has nothing to do with the fact that the template has no provision to show the Closed date as it's hardcoded there.
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
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
Re: Variable ticket closed on
Ok, thanks
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache