Thanks Arno, Unfortunately, I am using SQLite (the effort level has been too high for me to switch, since SQLite has been working fairly well for me), so this solution doesn't work for me. Thanks for the advice, though. I can certainly live with the order they are currently in; it would just be nice to see them in chronological order.
cheers, maria Arno Lehman wrote: Hi, I forgot to mention that this works with MySQL and is not exactly tuned for anything. It just did what I thought you wanted when I tried it here. Arno On 9/1/2006 10:48 PM, Arno Lehmann wrote: > > Hi, > > > > On 9/1/2006 10:19 PM, Maria McKinley wrote: > > >> >>Hello, >> >> >> >>I couldn't find anything in the documentation, so thought I'd ask. Is >> >>there anyway to get bacula to list the volumes in a pool in order of >> >>date LastWritten instead of MediaID? > > > > > > Add the following to your query.sql: > > > > # 21 > > :List Media for a pool, ordered by LastWritten > > *Enter Pool name: > > SELECT VolumeName,VolBytes/1024/1024/1024 AS GB,LastWritten from > > Media,Pool where Media.PoolId=Pool.PoolId AND Pool.Name='%1' ORDER BY > > LastWritten; > > > > Add fields to taste ;-) > > > > Arno > > > > >> >>thanks a bunch, >> >>Maria >> >> >> >>------------------------------------------------------------------------- >> >>Using Tomcat but need to do more? Need to support web services, security? >> >>Get stuff done quickly with pre-integrated technology to make your job easier >> >>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >> >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >> >>_______________________________________________ >> >>Bacula-users mailing list >> >>Bacula-users@lists.sourceforge.net >> >>https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
