PerformQueryManagerQuery.java

public NodeIterator getChildren() {
  QueryManager queryManager = session.getWorkspace().getQueryManager();
  String query = "SELECT * FROM [nt:unstructured] AS s "
               + "WHERE [title] IS NOT NULL "
               + "ORDER BY [created] DESC";
  Query query = queryManager.createQuery(query, Query.JCR_SQL2);
  
  // Set Offset
  if (offset != null) {
    query.setOffset(offset);
  }
  // Set Limit
  if (limit != null) {
    query.setLimit(limit);
  }
  
  QueryResult result = query.execute();
  return result.getNodes();
}