When I do a report like this using the Custom Query. I simply filter for Field IS '' (Leaving the filter field blank). That works great for me. I wouldn't use "contains".
On Wed, Oct 6, 2010 at 9:44 AM, janiv <[email protected]> wrote: > Thanks, > I'm using the UI report and not SQL (hence, query:) > I'm trying to use the filter as follow: Project contains ''. > It finds nothing, although I have some tickets with an empty project > field. > > I want to find all tickets with empty project field. > > Thanks, > Janiv. > > > > On Oct 6, 4:30 pm, Felix Schwarz <[email protected]> > wrote: > > Am 28.09.2010 15:29, schrieb janiv: > > > > > I have few custom fields that are text. > > > I want to create a report that filters according to one of these > > > fields, i.e. project. > > > If I want to find all the tickets that their project field is empty/ > > > blank/null, how do i achieve that> > > > > What about just looking for items where you specify that project is '' > > (no input in the text box)? > > > > If that doesn't work, you can always resort to SQL and explicitely check > > for the values that you consider empty. > > > > What specific problems did you have when trying your approach? > > > > fs > > -- > Follow Agilo on Twitter: http://twitter.com/agiloforscrum > Please support us by reviewing and voting on: > http://userstories.com/products/8-agilo-for-scrum > http://ohloh.net/p/agilo-scrum > http://freshmeat.net/projects/agiloforscrum > > You have received this message because you are subscribed to > the "Agilo for Scrum" Google Group. This group is focused on > supporting Agilo for Scrum users and is moderated by > Agilo Software GmbH <http://www.agiloforscrum.com>. > > To post to this group, send email to [email protected] > To unsubscribe from this group, send an email to > [email protected] <agilo%[email protected]> > For more options, visit this group at > http://groups.google.com/group/agilo > -- Thanks. Dean -- Follow Agilo on Twitter: http://twitter.com/agiloforscrum Please support us by reviewing and voting on: http://userstories.com/products/8-agilo-for-scrum http://ohloh.net/p/agilo-scrum http://freshmeat.net/projects/agiloforscrum You have received this message because you are subscribed to the "Agilo for Scrum" Google Group. This group is focused on supporting Agilo for Scrum users and is moderated by Agilo Software GmbH <http://www.agiloforscrum.com>. To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo
