From b47329ae81f37ccf40d34a39169d536a1855a21a Mon Sep 17 00:00:00 2001 From: Dirk H Bartley Date: Mon, 14 May 2007 14:53:35 +0000 Subject: [PATCH] Distinct seems to be needed when media is included in the search. Select results came back with 3 records identical. git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@4782 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/qt-console/joblist/joblist.cpp | 2 +- bacula/src/qt-console/joblog/joblog.cpp | 1 - 2 files changed, 1 insertion(+), 2 deletions(-) diff --git a/bacula/src/qt-console/joblist/joblist.cpp b/bacula/src/qt-console/joblist/joblist.cpp index a5ddf4ac38..89ec394333 100644 --- a/bacula/src/qt-console/joblist/joblist.cpp +++ b/bacula/src/qt-console/joblist/joblist.cpp @@ -127,7 +127,7 @@ void JobList::populateTable() int volumeIndex = volumeComboBox->currentIndex(); if (volumeIndex != -1) m_mediaName = volumeComboBox->itemText(volumeIndex); - query += "SELECT Job.Jobid AS Id, Job.Name AS JobName, Client.Name AS Client," + query += "SELECT DISTINCT Job.Jobid AS Id, Job.Name AS JobName, Client.Name AS Client," " Job.Starttime AS JobStart, Job.Type AS JobType," " Job.Level AS BackupLevel, Job.Jobfiles AS FileCount," " Job.JobBytes AS Bytes," diff --git a/bacula/src/qt-console/joblog/joblog.cpp b/bacula/src/qt-console/joblog/joblog.cpp index 3bc966f366..a042ced364 100644 --- a/bacula/src/qt-console/joblog/joblog.cpp +++ b/bacula/src/qt-console/joblog/joblog.cpp @@ -102,7 +102,6 @@ void JobLog::populateText() } /* foreach resultline */ if (resultcount == 0) { /* show a message about configuration item */ - printf("go here\n"); QMessageBox::warning(this, tr("Bat"), tr("There were no results ?? !!!.\n" "It is possible you may need to add \"catalog = all\" to the Messages stanza" -- 2.39.5