<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks michael, that worked great. I guess it does just come down to it not being intuitive, and the order of you doing things being very important.<div><br class="webkit-block-placeholder"></div><div>My general way of doing things is just to add all the fields I need to restrict on, and then just go advanced.</div><div><br class="webkit-block-placeholder"></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">Regards,</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">Matthew Watson.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><br class="webkit-block-placeholder"></div><div><div>On 17/07/2008, at 10:56 AM, Michael Brader wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Matthew Watson writes:<br><blockquote type="cite">Hi,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Just reviewing 3.8, very nice (love the new theme). One thing that <br></blockquote><blockquote type="cite">stuck me though, is that the search builder still seems to be very <br></blockquote><blockquote type="cite">difficult to use, and almost impossible (it seems) to do what should <br></blockquote><blockquote type="cite">be a simple thing without going into the advanced window.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">The Primary difficulty is constructing queries with variations of AND <br></blockquote><blockquote type="cite">and OR, and nesting,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">For example.. Constructing a fairly standard query like<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Subject LIKE 'abc123' AND Queue = 'General' AND ( Status = 'new' OR <br></blockquote><blockquote type="cite">Status = 'open' )<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">using the point/click search builder seems impossible, or at least, <br></blockquote><blockquote type="cite">not intuitive, I can't workout how to do it.<br></blockquote><br>I wouldn't say it is intuitive unless you've been doing it a few<br>years, but you can get your query above by:<br><br>Select 'Subject matches "abc123", Queue is general, and Status is new'<br>Hit add<br>Click to select "Status = 'new'" in the Current Search box<br>Click on the right arrow button to make it a subquery<br>Change the Aggregator to 'OR' and add the "Status = 'open'" clause<br>Hit add.<br><br><blockquote type="cite">Is this is a bug in the new version, or just the way query builder <br></blockquote><blockquote type="cite">works.. or am I just doing it wrong?<br></blockquote><br>In truth, I usually add about half of that then go to the advanced<br>box. My theory is that the interface is intuitive to the authors of<br>DBIx::SearchBuilder but presents challenges to the rest of us ;-)<br><br>Cheers,<br>Michael<br><br>-- <br>Michael Brader <a href="mailto:michael.brader@youramigo.com">michael.brader@youramigo.com</a><br><br>IMPORTANT - This email message is for the sole use of the intended <br>recipient(s) and may contain confidential and privileged information in <br>which case neither is intended to be waived. YourAmigo retains ownership of <br>all copyright, trade secrets and other intellectual property rights in the <br>email and attachments. Any unauthorized review, use, disclosure or <br>distribution is prohibited. If you are not the intended recipient, please <br>notify us and remove it from your system. It is your responsibility to check <br>any attachments for viruses and defects before opening or sending them on. <br>YourAmigo collects personal information to provide and market our services. <br>For more information about use, disclosure and access, see our privacy <br>policy at <a href="http://www.youramigo.com">http://www.youramigo.com</a><br><br><br>______________________________________________________________________<br>This email has been scanned by the MessageLabs Email Security System.<br>For more information please visit <a href="http://www.messagelabs.com/email">http://www.messagelabs.com/email</a> <br>______________________________________________________________________<br></blockquote></div><br></div></body><!--[object_id=#staff.netspacenet.au#]--><P align=left><FONT face=Arial size=1>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the organisation. Finally, the recipient should check this email and any attachments for the presence of viruses. The organisation accepts no liability for any damage caused by any virus transmitted by this email.</FONT></P></html>