Hi, On 26.05.2010, at 05:18, Arthur de Pauw wrote:
Can someone help me finding tickets that have no service assigned? I'd need a "negate search" or something like that. If it's done using a URL, I'm happy as well. I think I saw a query regarding something like this before, but I can't find it.
This can’t be done in the current GUI. The only solution I would have, is to execute a SQL statement via the Admin SQL Box. On MySQL this would be “select tn from ticket where service_id is NULL;" Please be so kind a file a bug about this: http://bugs.otrs.org It would be perfect if this would be available in Search, Generic Agent and Notification (Event) for all fields, right? Freundliche Grüße / Kind regards Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project