Hello Helmut Yes, it's possible! Take a look in the function "base64_decode_lstat" in my github: You need to use this way: SELECT base64_decode_lstat(8,LStat) FROM File WHERE JobId=XXX; https://github.com/wanderleihuttel/webacula/blob/master/install/MySql/update_tables_7.5.2_to_7.5.3.sh
Atenciosamente *Wanderlei Hüttel* Em ter., 3 de dez. de 2019 às 14:22, Helmut Ritter <jumpe...@gmx.de> escreveu: > Hi, > > is there a way to decode the lstat field within MySQL? I found solutions > with PHP, perl, postgres but not with MySQL. > > I want to see the file size in a query, e.g. in the default #12: > > # 12 > :List Files for a selected JobId > *Enter JobId: > SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=%1 > AND Filename.FilenameId=File.FilenameId > AND Path.PathId=File.PathId ORDER BY > Path.Path,Filename.Name; > > Thank you! > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
