Solved: I should use key format like this;
Code: Select all
'01||QueueName': ['DynamicFieldName'],
Code: Select all
'01||QueueName': ['DynamicFieldName'],
After optimize my query, it is working well. Thank you for your support.crythias wrote:Optimize your query.
Crash means locked:) My sql is working but my old version takes 3 minutes. But at the moment, it takes 54minutes.crythias wrote:If the db is crashed, repair it. Hope you have a backup.
Ok, our live system has over 20000 tickets. What is wrong i could not understand:(jojo wrote:well my testsystem has only a few tickets.
Sure? Is it working 3.3? When i try there is no response and DB was crashed:(jojo wrote:also the SQL works like a charm on a 3.3.
I know, but i should get it via SQL or function, because i will transfer these data to other database to report it. Please help me.jojo wrote:use the statistic type ticket list to get the info
Thank for your support. I need these two info for tickets. How can i get these two info? Any SQL command or function are helpfull for me.
Can you share these documents with me. When i run this sql, all tables are locked and OTRS is crashed.jojo wrote:there were a lot of changes. Check actual ERP diagram or SQL update script. Posting the error would also be good.