Query Builder search on Told

In query builder - how do I search on dates that are NULL? I have tried
Told = NULL and lots of other combinations… We are using RT 3.81

Thanks

Matt

This is a very basic SQL question. You need to go get a good book on
SQL. I recommend the pink book. (you’ll understand when you see it)

To answer your question: IS NULL not = NULL. But please don’t take
my answer and fail to purchase a good book on SQL.On Apr 24, 2009, at 11:22 PM, Matt Hoover wrote:

In query builder - how do I search on dates that are NULL? I have
tried Told = NULL and lots of other combinations… We are using RT
3.81

Thanks

Matt


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness

Joe-
Thanks for the recommendation :slight_smile: I am pretty familiar with SQL. My
question surrounds the RT QUERY BUILDER INTERFACE. I am not able to get
these correct sql queries around “NULL” to work in the query builder. Try
what you think will work in query builder. I have not been able to make it
work.

Trying something like: (except in query builder)
SELECT * FROM Tickets WHERE Told IS NULL AND STATUS != ‘Resolved’ …

Is there any way to pull this from the Query Builder interface? I would
like my users to be able to run this… Thanks

MattOn Mon, Apr 27, 2009 at 9:17 AM, Jo Rhett jrhett@netconsonance.com wrote:

This is a very basic SQL question. You need to go get a good book on SQL.
I recommend the pink book. (you’ll understand when you see it)
To answer your question: IS NULL not = NULL. But please don’t take my
answer and fail to purchase a good book on SQL.

On Apr 24, 2009, at 11:22 PM, Matt Hoover wrote:

In query builder - how do I search on dates that are NULL? I have tried
Told = NULL and lots of other combinations… We are using RT 3.81

Thanks

Matt


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source and
other randomness

Let me hit this up again. Is there a way to do this via an overlay? I also
saw a FromSQL file that looked promising… To refresh everyone - I need to
be able to enter to query in advanced query something like:

( Status = ‘open’ OR Status = ‘new’ ) AND ( Owner = ‘CurrentUser’ ) AND
( Starts < ‘today’ ) AND ( ( ‘CF.{Type of work}’ = ‘Standard Work’ ) OR (
‘CF.{Type of work}’ = ‘Engineering work required’ ) ) AND Told IS NULL

that last piece is not working for me… “Told IS NULL”

Help :slight_smile:

Thanks!

MattOn Tue, Apr 28, 2009 at 11:22 PM, Matt Hoover mhoover@thectogroup.comwrote:

Joe-
Thanks for the recommendation :slight_smile: I am pretty familiar with SQL. My
question surrounds the RT QUERY BUILDER INTERFACE. I am not able to get
these correct sql queries around “NULL” to work in the query builder. Try
what you think will work in query builder. I have not been able to make it
work.

Trying something like: (except in query builder)
SELECT * FROM Tickets WHERE Told IS NULL AND STATUS != ‘Resolved’ …

Is there any way to pull this from the Query Builder interface? I would
like my users to be able to run this… Thanks

Matt

On Mon, Apr 27, 2009 at 9:17 AM, Jo Rhett jrhett@netconsonance.comwrote:

This is a very basic SQL question. You need to go get a good book on
SQL. I recommend the pink book. (you’ll understand when you see it)
To answer your question: IS NULL not = NULL. But please don’t take my
answer and fail to purchase a good book on SQL.

On Apr 24, 2009, at 11:22 PM, Matt Hoover wrote:

In query builder - how do I search on dates that are NULL? I have tried
Told = NULL and lots of other combinations… We are using RT 3.81

Thanks

Matt


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source and
other randomness