Hi, On 9/3/2006 5:49 AM, Maria McKinley wrote: > Thanks Arno, > > Unfortunately, I am using SQLite
Have you tried the query? I guess it might well work, and if it doesn't, keeping this discussion going until the database experts are back from the weekend might help you getting a solution ;-) > (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. Basically, even if the query I suggested does not work, itshould be fairly simple to modify it for use with SQLite. Of course, patching the query in the source to add the "sort by..." part might also be an option. Arno > 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 -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- 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
