Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-1737

BM: Paused campaigns are seen in the MSN BM filter bar

    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'.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: