"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.3/core/src/cats/dml/0030_uar_sel_filesetid" (14 Sep 2021, 342 Bytes) of package /linux/misc/bareos-Release-20.0.3.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 # Select all different FileSet for this client
    2 # This query doesn't guarantee that the Id is the latest
    3 # version of the FileSet. Can be used with other queries that
    4 # use Ids to select the FileSet name. (like in accurate)
    5 
    6 SELECT MAX(FileSet.FileSetId)
    7   FROM FileSet
    8   JOIN Job
    9  USING (FileSetId)
   10  WHERE Job.ClientId = %s
   11  GROUP BY FileSet