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;"
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