sap-commerce-cloud - 灵活查询如何做UNION

Question

我想将 category_id 和 subCategory_id 合并到一列中。但我不知道如何在灵活查询中做到这一点。下面的代码是我想要做的

SELECT * FROM 

(SELECT
    ccr.targetpk as pk
    FROM
    Categories cc
    JOIN Cat2CatRel ccr ON cc.pk = ccr.sourcepk
    WHERE cc.p_code = '0106') 

UNION  SELECT CATE.pk as pk FROM CATEGORIES cate WHERE CATE.p_code = '0106'

我需要一个灵活的查询，其工作方式与上面的代码相同。

Answer 1

可以在灵活的搜索查询中进行联合。这是一个与您的案例类似的示例:

SELECT uniontable.PK FROM
(
   {{
      SELECT {cc:PK} as PK, {cc:code} AS CODE FROM {Categories AS cc}
      WHERE {cc:p_code} LIKE '0106'
   }}
   UNION ALL
   {{
      SELECT {ccr:PK} as PK, {ccr:code} AS CODE FROM {Cat2CatRel AS ccr}
      WHERE {ccr:p_code} LIKE '0106'
   }}
) uniontable

在这里您可以找到有关 Elasticsearch 的更多信息:Hybris Wiki