Olivier Delestre wrote:
> Pour infos, le dernier ordre sql ( buildind tree ) emis lors d'un
> restore->choix 5 sous la console :
>
> SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat
> FROM ( SELECT max(FileId) as FileId, PathId, FilenameId
> FROM ( SELECT FileId, PathId, FilenameId
> FROM File
> WHERE JobId IN (4032,4072))
> AS F GROUP BY PathId, FilenameId )
> AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId)
> JOIN Path ON (Path.PathId = Temp.PathId)
> JOIN File ON (File.FileId = Temp.FileId) WHERE File.FileIndex > 0
> ORDER BY JobId, FileIndex ASC
>
> A+
>
Je teste demain la même requète sur un équivalent de jobs.
--
Bruno Friedmann
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users-fr mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users-fr
