Details
-
Type: Bug
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Bid Management Tool
-
Labels:None
-
Environment:
Operating System: Windows XP
Platform: PC
-
Bugzilla Id:3240
Description
tested with Prod: trunk build 131 and Staging: trunk build 131
I am seeing both paused and active campaigns in the MSN filter bar right now.
I should only see active campaigns in BM.
This is the query UI seems to do:
select
distinct
`searchEngineAccounts`.`id` as `seacctid`,
`searchEngineAccounts`.`description` as `searchEngineAccounts.description`
from
`tsacommon`.`searchEngineAccounts`
INNER JOIN `tsacommon`.`distribution` ON
(`searchEngineAccounts`.`distributionID` = `distribution`.`id`)
LEFT JOIN `searchEngineGroups` ON (`searchEngineAccounts`.`id` =
`searchEngineGroups`.`searchEngineAccountID`)
where ((`distribution`.`channelID` = 1) and
((`searchEngineAccounts`.`accountID` in (17)) and
((`searchEngineAccounts`.`searchEngineStatus` = 'ok') or
((`searchEngineAccounts`.`searchEngineStatus` = 'disabled') and
(`searchEngineAccounts`.`paused` = 'true')))) and
(`searchEngineAccounts`.`enabled` = 'true') and
((`searchEngineGroups`.`id` is null) or
((`searchEngineGroups`.`accountID` in ('17')) and
((`searchEngineGroups`.`searchEngineStatus` = 'ok') or
((`searchEngineGroups`.`searchEngineStatus` = 'disabled') and
(`searchEngineGroups`.`paused` = 'true'))))) and
(`distribution`.`id` != 4) and
((`distribution`.`id` = '147') and
(`distribution`.`channelID` = 1))) order by
`searchEngineAccounts`.`description`
----------------------------------
Murty is also making a change in the backend. He added code to update paused
to 'true' and searchEngineStatus to 'disabled'.