我正在尝试使用获取一些数据FlexibleSearchQuery
但它响应空结果。如果我设置这个查询hac>Console>Flexible Search
我可以获得我想要的数据。
这是我在 java 文件中编写查询的方式。
sb.append(" SELECT {p:pk} ");
sb.append(" FROM {" + ProductModel._TYPECODE + " AS p} ");
sb.append(" WHERE {p:" + ProductModel.PK + " } IN ({{");
sb.append(" SELECT DISTINCT {pro:" + ProductModel.PK + "} ");
sb.append(" FROM {CategoryProductRelation AS cp},{" + ProductModel._TYPECODE + "! AS pro},{" + CategoryModel._TYPECODE
+ " AS c}");
sb.append(" WHERE {pro:" + ProductModel.PK + " } = {cp:target}");
sb.append(" AND {c:" + CategoryModel.PK + " } = {cp:source}");
sb.append(" AND {c:" + CategoryModel.CODE + " } !=?categoryCode }})");
args.put("categoryCode", categoryCode);
if (args != null && !args.isEmpty())
{
searchQuery.addQueryParameters(args);
}
这是我调用搜索的方式
final FlexibleSearchQuery searchQuery = new FlexibleSearchQuery(sb.toString());
searchResult.getResult().size() >> retuns 0
如果我在控制台中输入它
SELECT {p:pk} FROM { Product AS p} WHERE { p: pk } IN ({{
SELECT DISTINCT {pro: PK }
FROM
{CategoryProductRelation AS cp},
{Product AS pro},
{Category as c}
WHERE {pro: PK} = {cp:target}
AND {c:PK} = {cp:source}
AND {c:code} != '0101'}})
I get
PK
8796093579265
8796101804033
8796100165633
8796098428929
8796093153281
8796102361089
8796097052673
8796093808641
8796093972481
8796096823297
我究竟做错了什么?
控制台查询和字符串查询有什么区别吗?
我认为你的情况的问题与限制有关,根据定义:限制是FlexibleSearch遵守的规则,它允许根据搜索的类型和当前登录的用户来限制搜索结果
因此,在调用灵活搜索之前,请尝试禁用搜索限制
import de.hybris.platform.search.restriction.SearchRestrictionService;
...
// Disable search restrictions
searchRestrictionService.disableSearchRestrictions();
// some query goes here
// Enable search restrictions
searchRestrictionService.enableSearchRestrictions();
// some query goes here
另一方面,当您使用hac>Console>Flexible Search
我假设您以管理员身份登录,因此 Hybris 灵活搜索中默认禁用所有限制
您可以通过搜索类型来检查 HMC 中的所有活动限制:SearchRestriction
,看下面的截图
see : https://help.hybris.com/6.3.0/hcd/8c428f8286691014970ceee87aa01605.html https://help.hybris.com/6.3.0/hcd/8c428f8286691014970ceee87aa01605.html
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)