Search found 8 matches

by denionzz
26 Sep 2016, 12:27
Forum: Help
Topic: Select from mysql databases
Replies: 7
Views: 3160

Re: Select from mysql databases

I installed DinamichFildRemoteDB.
Excellent work, the information is taken from the database and inserted into the field. But what if you need to select more than one value at once a search? Insert the result into the table?
by denionzz
20 Sep 2016, 13:34
Forum: Help
Topic: Select from mysql databases
Replies: 7
Views: 3160

Re: Select from mysql databases

So you have a new table and you want to display its values in the ticket creation form. Correct? Yes, yes,yes... :) Do you want to store the selected value in the ticket? Oh sure! They will be saved along with the ticket. Do the shown values depend on other information (e.g. selected queue)? Yes! T...
by denionzz
20 Sep 2016, 08:58
Forum: Help
Topic: Select from mysql databases
Replies: 7
Views: 3160

Re: Select from mysql databases

I try :)
1. I have added a new table in the database OTRS
2. I would like to request to select data from a table on the form of the creation of the ticket
To do this, you need to write a new module? How to do it right and just?
by denionzz
19 Sep 2016, 12:52
Forum: Help
Topic: Select from mysql databases
Replies: 7
Views: 3160

Re: Select from mysql databases

There FIELD1 field.
I enter a value. I press the FIND button.
In the field of FIELD2, FIELD3 selected values on request "Select first_name,last_name from users WHERE id=FIELD1"
by denionzz
19 Sep 2016, 08:32
Forum: Help
Topic: Select from mysql databases
Replies: 7
Views: 3160

Select from mysql databases

You must make a request to the database and display the result on the form in the required field. After reading the documentation I came to the conclusion that it is necessary to use jquery + ajax + perl. Embed code in the template file, but the result will not be displayed. Prompt please, move and ...
by denionzz
19 Jan 2016, 08:00
Forum: Помощь
Topic: Поле "SolutionMin" формат времени....
Replies: 0
Views: 40383

Поле "SolutionMin" формат времени....

Добрый день! Кто нибудь нашел решения перевода времени в часы ? Где нужно поправить код чтобы время приняло формат часов, а не минут?
by denionzz
19 Jan 2016, 07:59
Forum: Help
Topic: How to display the field "SolutionMin" hours?
Replies: 1
Views: 687

Re: How to display the field "SolutionMin" hours?

Does not anyone tell me?
by denionzz
18 Jan 2016, 11:30
Forum: Help
Topic: How to display the field "SolutionMin" hours?
Replies: 1
Views: 687

How to display the field "SolutionMin" hours?

The reports OTRS field "Solution min" is displayed in minutes. How do I need to output to the format? For example, in hours