Znuny and ((OTRS)) Community Edition

If anyone is interested code is:

SELECT FIELD_ID, VALUE_TEXT, first_name, last_name
FROM dynamic_field_value, ticket, users
WHERE dynamic_field_value.field_id in (68,69) and ticket.id = OBJECT_ID and RESPONSIBLE_USER_ID = users.id

Thank you reneeb!

One more thing, is it possible to connect it with person who created this ticket and driven all this distance and spent his time?

Hello everyone, I have run into a problem working with SQL Box. I do not manage to get exact table information, for example what I am trying to get is from a ticket information a distance traveled and time. I manage to find tables, but do not manage to open them. SHOW OPEN TABLES do not work. SELECT...

One question, if I manualy copy and replace configuration files and var folder will my system update and keep the same? Or there are more files / folders to copy.

Best regards,
Marius

UPDATE: I downloaded a file manager tool on ubuntu server and now I manage to locate these files that I backed up. I do manage to find a configuration files in my backup. For some reason restore command do not use them. Picture attached.

I manage to detect Config.pm in old configuration. When I tried to copy it to updated otrs and then restore I run into error: ERROR: Already existing tables in this database. A empty database is required for restore! and when I delete it again the same error that there is no Config.pm file. Is it po...

I am beginner at linux server and not sure how to do that. Could please explain it more or just give me a link to explanation.

Thank you for quick responses,
Marius

The same thing happens.

I will attach image in order for you to understand better.

One more thing, I will write this in the same topic. Again I am trying to update OTRS. I am following steps from https://doc.otrs.com/doc/manual/admin/6.0/en/html/updating.html and did backup by http://doc.otrs.com/doc/manual/admin/4.0/en/html/backup-and-restore.html . I thought this will automatica...

Thank you!

Hello, I have running OTRS 6.06 and want to update it to OTRS 6.07 but I have ran into a problem. My otrs system is running on VM on ubuntu server and I cannot manage to remember OTRS console password. Is there a way to reset it or to find it? I need it to move files: root > sudo su otrs otrs > sudo...