Description
To get Linear space fields per Session or Scenes
Query :
To get Linear space fields per Session or Scenes
Query :
SELECT
A.SceneId,
A.AssetPurityId,
C.GroupId,
C.BlockNumber,
C.Shelf,
C.Position,
C.StockPos,
B.ProductWidthScaled,
B.ProductHeightScaled,
B.ShelfWidthScaled,
B.ShelfHeightScaled,
B.BlockWidthScaled,
B.BlockHeightScaled,
B.ScalingFactorBlock
FROM
AssetPurity A
JOIN
AssetPurityProductLinearSpace B ON A.AssetPurityId = B.AssetPurityId
JOIN
AssetPurityProduct C ON
B.AssetPurityId = C.AssetPurityId AND
B.ProductId = C.ProductId AND
B.StockPos = C.StockPos AND
B.GroupId = C.GroupId AND
B.BlockNumber = C.BlockNumber AND
B.Shelf = C.Shelf AND
B.Position = C.Position
WHERE
A.Clientid = 924
--------------------------------------------------