[步骤]
[结果]
[期望]
只针对亚马逊店铺
SELECT * FROM RB_Crawler_Task(nolock) where OrderSourceID='5058' and CreateTime>'2024-07-29' ;
重现步骤
[步骤]
[结果]
[期望]
只针对亚马逊店铺
SELECT * FROM RB_Crawler_Task(nolock) where OrderSourceID='5058' and CreateTime>'2024-07-29' ;
| 由谁创建 | 曾倩 于 2024-07-29 15:46:29 |
|---|---|
| 影响环境 |
测试环境-测试反馈 |
| 由谁解决 | 张明磊 于 2024-07-29 15:50:51 |
| 解决版本 | |
| 解决方案 | 程序BUG |
| 由谁关闭 | 曾倩 于 2024-07-31 09:57:50 |
| 最后修改 | 曾倩 于 2024-07-31 09:57:50 |
| 相关Bug |
|---|
IF
EXISTS #TmpSellerIds;
SELECT
DISTINCT api.DevIDSellerId into #TmpSellerIds
FROM
RB_OrderSource os ( nolock )
INNER JOIN RB_OrderSource_EbayAmazonAPI api ( nolock ) ON os.CustomerID = api.CustomerID
AND os.ID = api.OrderSourceID
WHERE
os.OrderSourceType = 1
AND os.IsActive = 1
AND os.CustomerId = 1
AND (os.ChannelPlatformStatus = 99 or CollectionChannelStatus > 1 or API.IsActive =0)
AND SourceStatus IN ( 0, 1, 2, 4 ) AND ISNULL(api.DevIDSellerId,'') <> '';
SELECT
api.OrderSourceID,
api.DevIDSellerId,
api.AppIDMarketplaceId,
os.SourceStatus,
ISNULL(os.ChannelPlatformStatus, 0) ChannelPlatformStatus,
os.OrderSourceCountry
FROM
RB_OrderSource os ( nolock )
LEFT JOIN RB_OrderSource_EbayAmazonAPI api ( nolock ) ON os.CustomerID = api.CustomerID
AND os.ID = api.OrderSourceID
INNER JOIN #TmpSellerIds tsIds ON tsIds.DevIDSellerId =api.DevIDSellerId
AND SourceStatus <> 3
WHERE os.OrderSourceType = 1