Hi, This already helps a lot. It would be more convenient if it goes over the web interface. I'll create a bug for that.
Thanks! Arthur On Thu, May 27, 2010 at 3:14 AM, Nils Leideck - ITSM < [email protected]> wrote: > 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/ > -- cheers, arthur
--------------------------------------------------------------------- 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/
