sorry for this query I am still getting the descendant nodes, and unable to get the current node.

Is there any way to query on the current node as well as its descendant nodes based on the below query? I also want to check whether the current node has [jcr:content/cq:lastReplicationAction] = 'Activate'SELECT DISTINCT page.[jcr:path] FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page, '/content/'...

I have a crawler to run JCR-SQL2 queries on author instance using AEM scheduler. Sometimes I would get WARN logs from AEM and the logs look something like this: *WARN*| [sling-default-4]| org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor| Index-Traversed 20000...

I was wondering what's the difference between Activate vs. Run in AEM scheduler? I am following this post: AEM 6.4 : Creating a Scheduler Using OSGi R6 Annotations | by Ankur Ahlawat | Adobe Tech Blog In this article, I don't see any scheduler related code inside the run() method. What kind of code ...

Thanks for the quick reply @VijayChintapalli. Do I need to have this "SimpleScheduledTaskConfig" interface inherit to the scheduler in order for it to show up on this endpoint: /system/console/configMgr?

I am following this tutorial on creating a scheduler: https://kiransg.com/2021/11/07/aem-scheduler-best-practices/  @ObjectClassDefinition(name="A scheduled task", description = "Simple demo for cron-job like task with properties")public @interface SimpleScheduledTaskConfig {     @AttributeDefinitio...

I am trying to append new line of text for different json files. But for some reason, each json file only has one line after the below code is executed but it shouldn't.  Node confNode = session.getNode("/etc");Node reportFileNode;Node contentNode;for (int jIndex = 0; jIndex < array.length(); jIndex...

I would like to get all the immediate folders from a given path. For example, I would like to query the 6 immediate folders under we-retail/en:  I found a similar post here: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-querybuilder-how-to-return-only-the-folders-unde...

I would like to write a query using JCR-SQL2 to return all component groups.  I tried the following but it is not returning anything:SELECT * FROM [componentGroup]  Does anyone have any suggestions? Thanks!

How to select multiple fields in a JCR-SQL2 query like such: SELECT page.[jcr:created], page.[jcr:createdBy], page.[jcr:primaryType] FROM [cq:Page] AS pageINNER JOIN [nt:base] AS component ON ISDESCENDANTNODE(component, page)WHERE component.[sling:resourceType] = '/libs/fd/af/components/aemform'AND ...