"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.2/core/src/cats/dml/0007_list_jobs_long" (10 Jun 2021, 915 Bytes) of package /linux/misc/bareos-Release-20.0.2.tar.gz:

As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. 
    1 #
    2 # "WHERE JobId > 0" is a dummy where clause,
    3 #                   to make it easier to extend the filter
    4 #                   (all filters starts with "AND ...")
    5 # JOIN with Media is required for filter to Media.Volumename.
    6 #
    7 
    8 SELECT DISTINCT Job.JobId, Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level,
    9 Job.ClientId, Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
   10 Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId, Job.VolSessionTime,
   11 Job.JobFiles, Job.JobBytes, Job.JobErrors, Job.JobMissingFiles, Job.PoolId,
   12 Pool.Name as PoolName, Job.PriorJobId, Job.FileSetId, FileSet.FileSet
   13 FROM Job
   14 LEFT JOIN Client ON Client.ClientId=Job.ClientId
   15 LEFT JOIN Pool ON Pool.PoolId=Job.PoolId
   16 LEFT JOIN JobMedia ON JobMedia.JobId=Job.JobId
   17 LEFT JOIN Media ON JobMedia.MediaId=Media.MediaId
   18 LEFT JOIN FileSet ON FileSet.FileSetId=Job.FileSetId
   19 WHERE Job.JobId > 0
   20 %s
   21 ORDER BY StartTime%s;