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 [email protected] [email protected] http://webint.cryptonode.de / a Fractal project
--------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
