Closed: Searching for "Is Not Null"

Moderator: crythias

Post Reply
RBehr
Znuny expert
Posts: 167
Joined: 26 Jan 2011, 13:23
Znuny Version: 3.0.7
Real Name: Rod Behr
Company: Impact
Location: London, United Kingdom
Contact:

Closed: Searching for "Is Not Null"

Post by RBehr »

Using the STATS module, I need to set restrictions against a specific, free text field. I need to return all ticket which have SOMETHING in this field and exclude all which are NULL or an empty string.

What is the wildcard syntax for this?
Last edited by RBehr on 25 Oct 2012, 10:40, edited 1 time in total.
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
RBehr
Znuny expert
Posts: 167
Joined: 26 Jan 2011, 13:23
Znuny Version: 3.0.7
Real Name: Rod Behr
Company: Impact
Location: London, United Kingdom
Contact:

Re: Searching for "Is Not Null"

Post by RBehr »

Could REALLY use a response to this one please. How do I enter criteria into a Stats report that returns all rows with a value in the field - the equivalent of an SQL "in not null" expression?
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Post Reply