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 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 <[email protected]> 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: [email protected] > > > 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 > > > >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
