Sorry for the late response. Unless you have already figured out the answers to the questions, here are quick pointers:
- Total articles/stories in site: To get all the pages that meets your search criteria, I guess you are looking at building search in OSGi using javax.jcr.query. Queries such as:
SELECT * FROM [cq:Page] AS s WHERE ISDESCENDANTNODE(s, '/content/yourapp').
Take a look at 9 JCR-SQL2 Queries Every AEM Developer Should Know | 6D Labs
- Unique id of all stories: Try jcr:uuid property
- All the nodes and properties for specific story (story = content + assets): Once you get the QueryResult, iterate through the Nodes and get their properties and values:
QueryManager manager = session.getWorkspace().getQueryManager();
Query query = manager.createQuery(queryStatement, Query.JCR_SQL2);
QueryResult results = query.execute();
NodeIterator nodeIterator = results.getNodes();
while (nodeIterator.hasNext()) {
Node node = (Node) nodeIterator.next();
if (node != null && node.hasProperty(“jcr:content/cq:lastReplicated”)) {
Property property = node.getProperty(“jcr:content/cq:lastReplicated”);
if (property != null){
String value = (property.getString());
}
}
}
You can pick and choose the property that you would like to read.
- By which property we can decide it is published or not? Try jcr:content/cq:lastReplicated
- How to get only published story list in api or querybuilder response? If you are running the query on Author, tweak the WHERE to include something like:
SELECT * FROM [cq:Page] AS s WHERE ISDESCENDANTNODE(s, '/content/yourapp') AND s.[ jcr:content/cq:lastReplicated] IS NULL
If you are running the query on Publish, you can skip the statement after AND, as someone must have published the story or content that it now is in the Publish, provided regular replication process has been used.
Hope that helps
