Read this thread. https://otrsteam.ideascale.com/a/dtd/Solution-Time-Clock-Stop/423644-10369 but this might help (?) a bit: http://forums.otterhub.org/viewtopic.php?f=53&t=14242#p68383
so if you want to exclude certain states, you can use, for example, a "AND th.state_id IN (1,4)" (new, open) in the bottom WHERE. On Tue, Mar 12, 2013 at 1:56 AM, Yousef Hamad <yha...@aspire-infotech.net>wrote: > Hi steve, > > > > How can to prevent the SLA from continuing its time when ticket is pending. > > > > Thanks, > > Yousef. > > > > > > > > > _______________________________________________________________________________________________________________________________________________________________________________________________________________ > > This message contains confidential information and is intended only for > the individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and > delete this e-mail from your system. E-mail transmission cannot be > guaranteed to be secured or error-free, as information could be > intercepted, corrupted, lost, destroyed, arrive late or incomplete, or > contain viruses. The sender therefore does not accept liability for any > errors or omissions in the contents of this message, which arise as a > result of e-mail transmission. If verification is required please request a > hard-copy version. > Any views or opinions presented in this email are solely those of the > author and do not necessarily represent those of the company. Employees of > Aspire Infotech are expressly required not to make defamatory statements > and not to infringe or authorize any infringement of copyright or any other > legal right by email communications. > > Aspire Infotech, 130 Queen Rania Street, PO Box 840098 Amman 11181 Jordan > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs