Workspace Filter in AEM

The filter is used to define what parts of the JCR repository will be inport or export during package installation or un-installation. The filter.xml file is present under META-INF/vault. filter.xml has below structure. It consist a set of filter elements which is having a mandatory root attribute and optional include and exclude child elements. Filter […]

AEM Log files

Access.log: It capture maximum information including IP, username, time stamp, request method, token information, request protocol, response code, which page we have requested and browser details Request.log: It has few information like- time stamp, which page we have requested, request method, response code and how much time to get a responded. History.log: This log basically […]

SQL2 Query | AEM

Fetch users node SELECT * FROM [rep:User] As user WHERE ISDESCENDANTNODE(user, ‘/home/users’) AND [rep:authorizableId] <> ‘anonymous’ AND [jcr:primaryType] <> ‘rep:SystemUser’ AND [rep:authorizableId] NOT LIKE ‘%@%’ ORDER BY [rep:authorizableId] ASC Search node having specific resourceType SELECT * FROM [nt:unstructured] As node WHERE ISDESCENDANTNODE(node, ‘/content’) and [sling:resourceType] LIKE  ‘%components/page/site’ Find the pages which does not have [cq:tags] […]