SELECT * FROM dbo.RB_WareHouse_Product (NOLOCK) WHERE CustomerID =1
AND WareHouseID IN (SELECT ID FROM dbo.RB_WareHouse (NOLOCK) WHERE CustomerID =1 AND WareHouseType =86 AND IsActive =1)
AND ISNULL(Title,'')<>''
重现步骤
SELECT * FROM dbo.RB_WareHouse_Product (NOLOCK) WHERE CustomerID =1
AND WareHouseID IN (SELECT ID FROM dbo.RB_WareHouse (NOLOCK) WHERE CustomerID =1 AND WareHouseType =86 AND IsActive =1)
开发报告
1.针对美客多国际平台，打印条码，在通过库存接口没有获取到title时，需要取产品库的多语言的西班牙语-字段产品因为名称
2.客户订单有库存直发导出，针对线上环境存在，订单备注和订单发货备注的内容超过了Excel单元格的最大存储为32,767，对订单备注和发货备注有一个切割 ，超过了32767，就只保留32767字符长度的内容