Znuny and ((OTRS)) Community Edition

I have just upgraded to OTRS5, I have issue with when I open a ticket zoom window it appears split across my dual monitors. I am using latest version of Chrome. Can anyone advise how to resolve this frustrating issue. See attached image.

I remember having same issue, adding a second order by fixed it for me e.g. SELECT ts.name state, th.name fromto , th.create_time createtime, th.ticket_id ticket_id, th.id, Coalesce((SELECT th2.create_time FROM ticket_history th2 WHERE th2.history_type_id IN (1,27) AND th2.ticket_id = th.ticket_id A...

Data loss occurred due to use of a 3rd party plugin (DynamicFieldRemoteDB), when we archived tickets the dynamic field value populated using this plugin was lost. We have extracted lost data from ticket_history table. We now need to insert data back into dynamic_field_value table e.g. INSERT into dy...

Is there a way to do it from DB as I am more familiar with SQL than webservice

Hello, I need to manually insert data back into table dynamic_field_value which was deleted when I archived some tickets: INSERT into dynamic_field_value (id,field_id,object_id,value_text) values( ,'27','5439','Test') Can someone advise how I can populate ID column with next available value. Thanks,...

Yes, this behaviour only affects customers being able to view the FAQs. Agents can view all FAQs approved or not approved.

Thanks Renee, is there any way to configure the quick state change without creating an article using your plugin?

Hello,

Is there any way to enable a quick state change function on ticket zoom screen.

We are using reneeb very useful QuickOwnerChange addon, anyone aware of something similar for quick state change?

Hello,

I would like configure for OTRS to automatically insert queue name into the title when viewing a ticket on ticket zoom page.

Can someone advise on how to accomplish this.

Thanks, Benjamin

It could be due to your local IP changing and failing IP session check.

If you don't want sessions to be restricted to the same IP you can change:

Config Options: Framework -> Core::Session
SessionCheckRemoteIP: Select No

The problem appears to be the sorting of the timestamps in custom_date column, I have added a 'order by th2.id' which fixes the issue but also causes the query to be too slow to run on whole DB. Can anyone optimize below corrected query? SELECT th.id, ts.name state, th.name fromto, th.create_time cr...

I have noticed an issue when using Crythias's sql, the custom_date is not picking up the next state change correctly instead as shown in the example below, the bottom two result have the same custom_date causing duplication in pending time calculation %%Awaiting Acknowledgement%%Awaiting Customer In...

Thank you for Welcome.

Correct, the subject is mandatory however problem is the 'Subject' field auto-populates with ticketID so it passes this rule. I need to force agents to append a subject to the ticketID.

Hello OTRSers,

Some of our agents forget to add a subject when using 'Email Outbound' feature in OTRS.

I want to restrict sending of emails where no subject has been added by agent, can anyone advise if/how this could be achieved using an ACL?

Thanks,
Benjamin