灵活的搜索问题SAP Hybris

Question

我对灵活的查询有问题。这是我的疑问：

Select
{pp.productCode} as 'Code',
{p.descriptionCics} as 'Desc CISC',
{bs.uid} as 'Store',
{evo.code} as 'Status', 
{p.department} as 'Department', 
{pca.name} as 'Category',
{p.grm} as 'GRM',
{p.buyerCode} as 'Code Buyer',
{p.buyerids} as 'Buyer', 
{ps.planogramCode} as 'Code Planogram',
{pca.categoryCode} as 'Category Planogram',
{s.puvmBlock} as 'Blocked',
(CASE WHEN ({p.productDetailTypeList} is not null )THEN 'YES' else 
'NO' END) as 'IMAGE'
from 
{ 
Product as p
JOIN PlanogramProducts as pp on {p.code} = {pp.productCode}
JOIN StockLevel as s on {pp.productCode} = {s.productCode}
JOIN EnumerationValue as evo on {p.status} = {evo.pk}
JOIN PlanogramCategory as pc on {pp.planogramCode} = 
 {pc.planogramCode}
JOIN PlamnogramCategoryAnag as pca on {pc.categoryCode}= 
{pca.categoryCode}
JOIN BaseStore as bs JOIN PlanogramStore as ps on {bs.storeRef} = 
{ps.storeRef} AND {bs.bramchOffice} = {ps.branchOffice}
}
WHERE 1=1

这是我执行时的错误：

有人能帮我吗？谢谢。

Answer 1

你的陈述有错误。你加入basestore和Planogram Store。但planogram store和basestore都不会与查询的任何其他部分连接。您需要将basestore或planogramstore与其他表之一连接起来。

现在，您的from语句中有两个分离的部分，这就是为什么您会出现错误

Product as p
JOIN PlanogramProducts as pp on {p.code} = {pp.productCode}
JOIN StockLevel as s on {pp.productCode} = {s.productCode}
JOIN EnumerationValue as evo on {p.status} = {evo.pk}
JOIN PlanogramCategory as pc on {pp.planogramCode} = 
 {pc.planogramCode}
JOIN PlamnogramCategoryAnag as pca on {pc.categoryCode}= 
{pca.categoryCode}

和

JOIN BaseStore as bs JOIN PlanogramStore as ps on {bs.storeRef} = 
{ps.storeRef} AND {bs.bramchOffice} = {ps.branchOffice}

你需要在这两个部分之间进行连接才能获得正确的数据