Re: [otrs] Dynamic Fields... direct access in the DB

Hops… answer to myself SELECT id, name, trim(regexp_replace(line, '.*:([^:]*)', '\1')) as value_text, trim(regexp_replace(line, '([^:]*):.*', '\1')) as display_name FROM (SELECT dynamic_field.id, dynamic_field.name, regexp_split_to_table(dynamic_field.con

Re: [otrs] Dynamic Fields... direct access in the DB

Hello Renée, Thank you for your idea. This is definitely an option - I could even create this table automatically at the beginning of my SQL query using WITH or something similar. Although doing this purely in SQL is not a super-ex

Re: [otrs] Dynamic Fields... direct access in the DB

Hi, I would do it that way: * Create a new table wingo_df_values (field_id, field_key, field_value) with unique (field_id, field_key) * change the backend module for Dropdown fields where the possible values are stored to the new table (every time the dynamic field is changed) * use that new

[otrs] Dynamic Fields... direct access in the DB

Hello dear list, I’m trying to export a list of tickets directly from the OTRS DB - I’m computing 20 columns, there are 7 joins… the request is not that small… And it takes approx. 50 seconds to generate 5’000 rows I need. Knowing that I will eventually need to export much more than 5’000 rows,

[otrs] Manually fetch the emails is not working

Hi all, I've just migrated from OTRS v4.0.8 on windows appliance to OTRS v5.0.10 on a Fedora 23 station. All seems to be fine. Except... fetching the emails manually. When I try to fetch the emails with the link on the postmaster page in Admin zone, I receive the error below. I wonder if

Re: [otrs] Memory usage rising from 4.x -> 5.0.9

Hello Ralf, this is strange. The biggest changes would have to be expected when upgrading to OTRS 4, because there we added a centralized in-memory cache which should increase performance but partly also could lead to higher memory usage. For OTRS 5 there should be no such effect. How big are

Re: [otrs] How to translate a message in Kernel/System/*.pm

Hello Ur, this looks broken. I believe that Translate() should be used on this string, and it should be changed to have a placeholder replaced by Translate() with the process name. Martin Gruner Team Lead R&D OTRS AG Bahnhofplatz 1a 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818

Re: [otrs] Packages dependencies on SLES11

Hello Marki, thanks for the hint. I removed the package »bash-completion« from the dependency list, future packages will be fixed. Martin Gruner Team Lead R&D OTRS AG Bahnhofplatz 1a 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg,