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
( Star
Joe-
Thanks for the recommendation :) 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
w
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,
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.be