Query Builder

Hi Amogh,

Take a look at this article which describes for your use case.

https://helpx.adobe.com/experience-manager/using/using-query-builder-servlet.html

Thanks,
Ratna Kumar.

The thread from Ratna is good at learning how to use QueryBuilder API within an OSGi service. However - this question is about a specific query. I will see if we have good examples that can show the syntax for this type of query.

Hi 

Can you try below query this may help you

path=/content
nodename=nodename(node name you want to search)
1_group.1_property=propertyname(Which property you need to search)
1_group.1_property.operation=not

Hi,

Using the Query Builder, you can design your own query. 

Like, create a servlet and inside it, define Query Builder, crate a map & execute createQuery. See the code below: 

@Reference private QueryBuilder builder; map.put(path,<path of node or folder containing ndoes>); map.put(p.nodedepth,<node depth>); map.put(nodename, <node name>); map.put(p.limit,<max limit>); map.put(p.hits,<no of hits>); map.put(property,<property name>); map.put(property.value,<proerty value>); map.put(orderBy,<orderby clause>); Query query = builder.createQuery(PredicateGroup.create(map), session); SearchResult result = query.getResult(); Iterator<Resource> iterator = result.getResources();

I hope, it'd be helpful.

korthivada wrote...

Hi 

Can you try below query this may help you

path=/content
nodename=nodename(node name you want to search)
1_group.1_property=propertyname(Which property you need to search)
1_group.1_property.operation=not

 

 

smacdonald2008 wrote...

For this use case - you are not searching for pages with a specific property. If that was the case - it would be much better as you could search for a page with a specific property - as talked about in this section: 

https://docs.adobe.com/docs/en/aem/6-1/develop/search/querybuilder-api.html  (in the Search for properties section)

The property is actually on a child node (i assume type nt:unstructured) - for example: 

Now because of this - you cannot search for specific page with a property. This does not work since the page does not have the property. 

What you can do is use JCR SQL2 and search for nodes of type cq:Page. To make the code faster - you can specify a path in the JCR to search. For example: 

String sqlStatement = "select * from [cq:Page] where isdescendantnode('/content/geometrixx-outdoors') ";

For each result set - check to see if there is a child node named contactform. If so - see if that has an id property that is empty or null. If you find this - place the node into a Java collection.

Once you iterate through your result set - you will get all of the pages that have a child node with an empty id property. 

 

 

 

 I have already tried this and its giving almost hundreds of result and so it difficult to iterate each and every page for required property. I just want query which we can run through query builder or from crxde.

If you have hundreds of pages under /content - that is true. If you can narrow your search using a more specific JCR path under /content- it will reduce the result set to iterate over. However - if you need all pages under /content - then you cannot do this. 

Have you tired the suggestion by himanshusinghal?  

Also - what do you need this for. Are you using this for a report of pages and you will only run this every so often?

You are not using this logic in a web page or AEM app are you? I mean the performace will not effect any AEM app. If you need it for a report - i would do JCR SQL - it may be slower - but it will be the best way. 

I am going to test this and report back!!