Ärende i NSP: REQ0083376

Ärende i Devops:
Product Backlog Item 28895 Adtraction-integration: koppla på två nya kampanjkoder

---

Detta kan vi på MU göra själva med nedan script:

SELECT * FROM PD_Users WHERE VCHUSERNAME = 'adtraction'

SELECT * FROM [productdb].[dbo].[PD_Offer] WHERE campaignCode IN ( 'adtrkampanj12man', 'perks12man' ) ORDER BY offerName

SELECT * FROM [productdb].[dbo].[PD_OfferFilter] WHERE ip = (SELECT VCHUSERNAME FROM PD_Users WHERE VCHUSERNAME = 'adtraction')

SELECT * FROM [productdb].[dbo].[PD_OfferFilter] WHERE ip = 'adtraction'

/*
INSERT INTO [productdb].[dbo].[PD_OfferFilter] ( [ip], [allowOfferIds], [denyOfferIds], [description], [updateby], [updatedate], [insertdate], [insertedby] )

    SELECT 'adtraction', offerId, NULL, campaignCode, 'SKAB\xjsbm', GETDATE(), GETDATE(), 'SKAB\xjsbm' FROM [productdb].[dbo].[PD_Offer] WHERE campaignCode IN ( 'adtrkampanj12man', 'perks12man' ) ORDER BY offerName
*/

SELECT * FROM [productdb].[dbo].[PD_OfferFilter] WHERE ip = 'adtraction'