[SOLVED] Add events in calendar by SQL

[Rick]

Hello,

I want to add an events in the calendar of the dashboard.
I add in the table dynamic_field_value by INSERT INTO with correct values but the ticket is not in the calendar.
Can i do this ?

Thanks

[RStraub]

Adding dynamic field values will not suffice. You'll need:
- a ticket
- in the specified queue
- with start and ending values in the specified dynamic fields

If you need to do it "outside of the webfrontend", rather use the generic interface to create a proper ticket.
Fiddling with the db is something I wouldn't recommend.

[Rick]

I have the ticket, so i use the ticket_id. How can i use the generic interface ?

[Rick]

What i wand to do : create automatically two dynamic fields when the state of a ticket change to pending reminder.
I want to use the same value for EventsStart and EventsEnd with the date of pending reminder, for show in one box (day of reminder).
Sorry for the shitty English, I'm French

[RStraub]

Allright. In that case I would suggest to write a custom module which is triggered on StateUpdate and filtered to pending reminder.

If it is triggerd, it reads the reminder date and sets the values to the two fields which you configured in SysConfig.

[Rick]

I has made a trigger with mysql for insert into the table dynamic_field_value but i think it miss something because my ticket not appear in the calendar whereas the other since the form are visible

[Rick]

There an other table to update ?

[root]

The recommendation was to use OTRS's event to trigger the update to the two dynamic fields.
But to answer your question: is this ticket you talk about in one of the queue you've configure to be shown in the calendar?
That's the code where the relevant ticket search ist done: https://github.com/OTRS/otrs/blob/maste ... ar.pm#L118

[Rick]

Oh yess !
I found the solution in other post in deutsch : viewtopic.php?t=25496

Thanks bro'