[SOLVED] Pending reminder table / column

Moderator: crythias

Post Reply
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

[SOLVED] Pending reminder table / column

Post by Rick »

Hello,

Now, i want to know in which table is stored the data for pending reminder.
Thanks'
Last edited by Rick on 09 Jun 2015, 12:02, edited 5 times in total.
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: Pending reminder table

Post by EXG133 »

You mean the Agent::PendingReminder at the http://server/otrs/index.pl?Action=AdminNotification ? These are in the table NOTIFICATIONS
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

Re: Pending reminder table

Post by Rick »

No, just the table which contain the value of the date when i set the state of the ticket to pending reminder.
Where is stored the date ? In which table ?
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

Re: Pending reminder table

Post by Rick »

I search the table which contain the date of pending reminder for a ticket
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Pending reminder table

Post by RStraub »

After pocking me with pms, I had another look into the ticket table. The column until_time seems to save the pending date in unix time.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

Re: Pending reminder table

Post by Rick »

Nope, it's an other field :(
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

Re: Pending reminder table

Post by Rick »

i think it's in another table from ticket
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Pending reminder table / column

Post by RStraub »

Why? For me that column changed after I did nothing but setting a pending reminder.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Rick
Znuny newbie
Posts: 57
Joined: 30 Apr 2015, 09:24
Znuny Version: 4.0.7

Re: Pending reminder table / column

Post by Rick »

Yes i made an error ! It's work fine.
Sorry :lol:
Post Reply