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 < nils.leideck@leidex.net> 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

nils.leideck@leidex.net nils.leideck@otrs.com

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