"Fossies" - the Fresh Open Source Software Archive 
Member "bareos-Release-21.1.4/core/src/cats/dml/0007_list_jobs_long" (5 Aug 2022, 1085 Bytes) of package /linux/misc/bareos-Release-21.1.4.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.
See also the last
Fossies "Diffs" side-by-side code changes report for "0007_list_jobs_long":
21.1.3_vs_21.1.4.
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,
11 CASE
12 WHEN Job.endtime IS NOT NULL AND Job.endtime >= Job.starttime THEN Job.endtime - Job.starttime
13 ELSE CURRENT_TIMESTAMP(0) - Job.starttime
14 END as Duration,
15 Job.JobTDate, Job.VolSessionId, Job.VolSessionTime,
16 Job.JobFiles, Job.JobBytes, Job.JobErrors, Job.JobMissingFiles, Job.PoolId,
17 Pool.Name as PoolName, Job.PriorJobId, Job.FileSetId, FileSet.FileSet
18 FROM Job
19 LEFT JOIN Client ON Client.ClientId=Job.ClientId
20 LEFT JOIN Pool ON Pool.PoolId=Job.PoolId
21 LEFT JOIN JobMedia ON JobMedia.JobId=Job.JobId
22 LEFT JOIN Media ON JobMedia.MediaId=Media.MediaId
23 LEFT JOIN FileSet ON FileSet.FileSetId=Job.FileSetId
24 WHERE Job.JobId > 0
25 %s
26 ORDER BY StartTime%s;