Search for substring in a node name in JCR using CQ querybuilder

0
votes

I am trying to do a search in CRXDE in CQ using the CQ qurybuilder tool to find all node names(in the tree structure) that contain the character '#' but am not successful. Being new to the Querybuilder tool, I am not aware of the exact conditions to be used to do the same. Kindly help.

I tried the following query in the /bin/querybuilder.json tool-type=nt:file&path=/content/dam/marketinghub&property=nodename&property.value=#

I think the property=nodename part is wrong. What should I mention as property name when I have to search in the node names itself and not in any specific property of the node?

1
xpathaemquery-buildercrx

1 Answers

1
votes

Almost there, but it is not the property that you need to search, it is the name of the node. You have a nodename predicate that gets this job done for you.

It accepts a pattern that you would like to search for. So in your case, the query would be

type = nt:file
path = /content/dam/marketinghub
nodename = *#*

The json querybuilder url would be 

/bin/querybuilder.json?nodename=*%23*&path=%2fcontent%2fdam%2fmarketinghub&type=nt%3afile

For further learning on query builder, refer this doc.