Following JSP explains how to access a JCR query in AEM Component.
<%@include file="/libs/foundation/global.jsp"%><%
%><%@page session="false" %>
<%@ page import = "java.util.HashMap,
java.util.Map,
javax.jcr.Node,
javax.jcr.NodeIterator,
javax.jcr.Session,
org.apache.sling.api.SlingHttpServletRequest,
javax.jcr.query.Query,
javax.jcr.query.QueryManager,
javax.jcr.query.QueryResult" %>
<%
String sqlStatement="";
try
{
Session session = resourceResolver.adaptTo(Session.class);
QueryManager queryManager = session.getWorkspace().getQueryManager();
sqlStatement = "SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/forms/af])";
Query query = queryManager.createQuery(sqlStatement, "JCR-SQL2");
QueryResult result = query.execute();
NodeIterator nodeIter = result.getNodes();
while ( nodeIter.hasNext() )
{
Node node = nodeIter.nextNode();
out.print("<p>"+node.getName()+"</p>");
}
}
catch(Exception e)
{
out.print(e);
}
%>
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.