AEM Query

最新推荐文章于 2025-05-15 17:07:17 发布

转载最新推荐文章于 2025-05-15 17:07:17 发布 · 336 阅读

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/slightScenery/blog/1923163

本文深入探讨了Adobe Experience Manager (AEM)中使用SQL2和查询构建器API进行内容搜索的方法。详细介绍了如何通过构建查询语句来筛选特定路径下含有关键词的节点，以及如何利用查询构建器API创建复杂的查询条件，实现更精准的内容检索。

AEM Query

Two ways about Query

SQL2:

String sql = "SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([" + searchPath + "]) and (CONTAINS('"

+ titleProperty + "', '" + keywords + "') or CONTAINS('"

+ titleDesc + "', '" + keywords + "'))";

private QueryResult searchResult(Session session, String sql) {

QueryResult result = null;

try {

QueryManager queryManager = session.getWorkspace().getQueryManager();

Query query = queryManager.createQuery(sql, Query.JCR_SQL2);

result = query.execute();

} catch (Exception e) {

e.printStackTrace();

}

return result;

}

Query:

private JSONObject getGlobalSearch(SlingHttpServletRequest request, Session session, String searchPath,

String keywords, JSONObject object){

if(keywords.equals("")){

keywords = "*";

}

else{

keywords = "*"+keywords+"*";

}

String fulltextSearchTerm = keywords;

// create query description as hash map (simplest way, same as form post)

Map<String, String> map = new HashMap<String, String>();

// create query description as hash map (simplest way, same as form post)

// path=/main/path/where

// group.1_property=myProperty

// group.1_property.operation=exists

// group.1_property.value=true

// 2_group.p.or=true

// 2_group.p.not=true

// 2_group.3_path=/main/path/where/first/you/donot/want/to/search

// 2_group.4_path=/main/path/where/second/you/donot/want/to/search

map.put("path", "/content/studyconnect/us/en");

map.put("type", "cq:page");

map.put("group.p.or", "true"); // combine this group with OR

map.put("group.1_fulltext", fulltextSearchTerm);

// map.put("group.1_fulltext.relPath", "jcr:content");

map.put("group.1_fulltext.operation", "like");

// map.put("group.2_fulltext", fulltextSearchTerm);

// map.put("group.2_fulltext.relPath", "jcr:content/@cq:tags");

// map.put("2_group.p.or", "false");

// map.put("2_group.p.not", "true");

// map.put("2_group.3_property", "jcr:createdBy");

// map.put("2_group.3_property.value", fulltextSearchTerm);

// map.put("2_group.3_property.operation", "not");

// 2_group.3_path=/main/path/where/first/you/donot/want/to/search

// 2_group.4_path=/main/path/where/second/you/donot/want/to/search

// can be done in map or with Query methods

// map.put("p.offset", "0"); // same as query.setStart(0) below

map.put("p.limit", "-1");

Query query = builder.createQuery(PredicateGroup.create(map), session);

// query.setStart(0);

// query.setHitsPerPage(-1);

SearchResult result = query.getResult();

if (result != null) {

List<JSONObject> glossaries = new ArrayList<>();

Iterator<Node> nodes = result.getNodes();

try{

while (nodes.hasNext()) {

Node node = nodes.next();

JSONObject obj = new JSONObject();

obj.put("path", node.getPath());

glossaries.add(obj);

}

object.put("glossaries", glossaries);

}catch(Exception e){

e.printStackTrace();

}

return object;

}

fulltext does not search with system properties, Example: jcr:createdBy

参考：

https://helpx.adobe.com/experience-manager/using/using-query-builder-servlet.html

https://github.com/Adobe-Consulting-Services/acs-aem-samples/blob/master/bundle/src/main/java/com/adobe/acs/samples/search/querybuilder/impl/SampleQueryBuilder.java

https://gist.github.com/floriankraft/8b3720464318cd5cd9e2

https://hashimkhan.in/2017/10/09/digest-the-query-builder-api-aem-search-tips/

转载于:https://my.oschina.net/slightScenery/blog/1923163