|
From: Brian N. <no...@no...> - 2002-06-07 20:52:55
|
Bradley Miller wrote: > On the filtering issue for projects, this works: > > SELECT *,(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(date_modified)) as > age,UNIX_TIMESTAMP(date_added) AS added_ts FROM tickets WHERE > (1) AND (status != '7' AND status != '9') AND (creator = '1') AND ( > project IN(3,4,5,1,2) > OR (creator = 1) OR (owner = 1)) *and project = 5 *ORDER BY status DESC > LIMIT 0,15 > > Now I just need to see if there's a place in the code to add that fairly > painlessly? > > -- Bradley Miller > _______________________________________________________________ > Don't miss the 2002 Sprint PCS Application Developer's Conference August > 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > _______________________________________________ Bugin-users mailing list > Bug...@li... > https://lists.sourceforge.net/lists/listinfo/bugin-users there is a new test set up, fixing this problem. most of the code was already there, it jsut got masked by some other things -- give it a whirl. |