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:<br><br>( 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<br>
<br>that last piece is not working for me.... "Told IS NULL"<br><br>Help :) <br><br>Thanks!<br><br>Matt<br><br><br><div class="gmail_quote">On Tue, Apr 28, 2009 at 11:22 PM, Matt Hoover <span dir="ltr"><<a href="mailto:mhoover@thectogroup.com">mhoover@thectogroup.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Joe-<div><br></div><div>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.</div>
<div><br></div><div>Trying something like: (except in query builder)</div><div><div>SELECT * FROM Tickets WHERE Told IS NULL AND STATUS != 'Resolved' ....</div></div><div><br></div><div>Is there any way to pull this from the Query Builder interface? I would like my users to be able to run this.... Thanks</div>
<div><br></div><div><font color="#888888">Matt</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Mon, Apr 27, 2009 at 9:17 AM, Jo Rhett <span dir="ltr"><<a href="mailto:jrhett@netconsonance.com" target="_blank">jrhett@netconsonance.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="">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)<div><br></div><div>To answer your question: IS NULL not = NULL. But please don't take my answer and fail to purchase a good book on SQL.<br>
<div><br><div><div>On Apr 24, 2009, at 11:22 PM, Matt Hoover wrote:</div><blockquote type="cite">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<br>
<br>Thanks<br><br>Matt<br> _______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com" target="_blank">sales@bestpractical.com</a><br>
<br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br>Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a></blockquote></div><br><div>
<span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div style="">
<div><div style="margin: 0px;"><font face="Helvetica" size="3">-- </font></div><div style="margin: 0px;"><font face="Helvetica" size="3">Jo Rhett</font></div>
<div style="margin: 0px;"><font face="Helvetica" size="3">Net Consonance : consonant endings by net philanthropy, open source and other randomness</font></div></div><div>
<br></div></div></span><br> </div><br></div></div></div></blockquote></div><br></div></div></div>
</blockquote></div><br>