Eric added this to the current code -- it will be in the next release.
Thanks.
Kern
On Wednesday 06 January 2010 00:43:07 Dan Langille wrote:
> Holger Mueller wrote:
> > Hi,
> >
> > is it possible to modify the sql query to get alphabetical
> > order of clients when selecting the most recent backup for a client?
> >
> > A patch for recent git version of bacula looks like this:
> >
> > ----8<------------
> > diff --git a/bacula/src/cats/sql_get.c b/bacula/src/cats/sql_get.c
> > index 95dbf32..4e34e73 100644
> > --- a/bacula/src/cats/sql_get.c
> > +++ b/bacula/src/cats/sql_get.c
> > @@ -568,7 +568,7 @@ int db_get_client_ids(JCR *jcr, B_DB *mdb, int
> > *num_ids, uint32_t *ids[])
> >
> > db_lock(mdb);
> > *ids = NULL;
> > - Mmsg(mdb->cmd, "SELECT ClientId FROM Client");
> > + Mmsg(mdb->cmd, "SELECT ClientId FROM Client ORDER BY Name");
> > if (QUERY_DB(jcr, mdb, mdb->cmd)) {
> > *num_ids = sql_num_rows(mdb);
> > if (*num_ids > 0) {
> > ----8<-----------
>
> FWIW, I have often thought about having this. :)
>
> ---------------------------------------------------------------------------
>--- This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Bacula-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-devel
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
