如何在 Hybris Jasper 报告中使用灵活搜索"dynamic"搜索字段类型=？

Question

例如：

    SELECT 
 {adjustment.pk},
 {reason.code},
 {reason.description},
 {adjustment.orderNumber}
 {adjustment.creator},
 {cs.agentID},
 {cs.mobilePhone}
  FROM  {OrderValueAdjustment as adjustment JOIN AdjustOrderReason AS reason ON {adjustment.reason} = {reason.pk}
    JOIN CsEmployee AS cs ON  {adjustment.creator} = {cs.pk}
  }
WHERE {adjustment.pk} = 8796093131124

抛出 false，因为{adjustment.orderNumber}是动态属性类型。

Answer 1

动态属性不是持久性属性，因此无法使用灵活查询进行搜索。

Answer 2

动态属性不会保存在数据库中，因此您无法使用 FLexible Search 获取它们。

为了解决 Jasper 报告的问题，如果您仔细查看 jrxml 文件(例如 salesByCountry.jrxml(，您将看到以下部分：

<queryString>
            <![CDATA[SELECT x.COUNTRY AS COUNTRY, SUM(x.TOTPRICE) as TOTPRICE
FROM
({{
Select {country.name} as COUNTRY, COALESCE(sum({o.totalPrice} * {c2.conversion}/{c.conversion}),0) as TOTPRICE
from { Country AS country LEFT JOIN Address AS a ON {a.country}={country.PK} LEFT JOIN Order AS o ON {o.paymentAddress}={a.PK} LEFT JOIN Currency as c ON {o.currency}={c.PK} LEFT JOIN Currency as c2 ON {c2.pk}= $P{Currency} AND {o.creationtime} >= $P{From} AND {o.creationtime} < $P{To}}
GROUP BY {country.PK}, country
}}
UNION ALL
{{
Select {country.name} as COUNTRY, COALESCE(sum({o.totalPrice} * {c2.conversion}/{c.conversion}),0) as TOTPRICE
from { Country AS country LEFT JOIN Address AS a ON {a.country}={country.PK} LEFT JOIN Order AS o ON {o.paymentAddress}={a.PK} LEFT JOIN Currency as c ON {o.currency}={c.PK} LEFT JOIN Currency as c2 ON {c2.pk}= $P{Currency} AND {o.creationtime} >= $P{From} AND {o.creationtime} < $P{To} AND {o.paymentAddress} IS NULL}
GROUP BY {country.PK}, country
}}) x
GROUP BY COUNTRY
ORDER BY TOTPRICE DESC]]>
        </queryString>

您可以做的是使用这种灵活的按参数搜索替换数据检索(作为 jrxml 中的货币(。然后，您只需从 java 中的模型获取动态值，并使用参数映射将其传递给 jasper 报告。