That means we cannot do case sensitive full text search i.e I cannot use this query and get only those nodes which has 'STATUS' only in upper case.:SELECT s.* FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE(s, [/etc/content/test]) AND CONTAINS(s.*, 'STATUS') ORDER BY LOWER(s.titleSimplified). Rega...

Hi Kautuk,The query you mentioned does equals search whereas my requirement is contains search since I want to search for string anywhere inside the jcr:content node.Also I want case-sensitive contains search and not case insensitive.Regards,Shallu Rohilla

Hi,I want to find all cq:PageContent nodes which has word like "STATUS" inside child nodes. I am using CONTAINS clause as the word "STATUS" is value of property of child node of cq:PageContent node. Using equals or LIKE return no result as this property is inside child node.. However my issue that I...

Thanks Kunal.That helps!!

Actually I am getting error on calling query.execute method itself(see the underlined code).        QueryManager queryManager = session.getWorkspace().getQueryManager();        Query query = queryManager.createQuery(statement, Query.JCR_SQL2);        query.setLimit(nodeSearchCriteria.getLimit());   ...

Hi,I am running an INNER JOIN query(javax.jcr.query.Query). I am getting an exception:javax.jcr.RepositoryException: This query result contains more than one selector .However when I am running this query directly in CRXDE it runs fine. Any idea.Sample query:SELECT parent.* FROM [cq:Page] AS parent ...

Hi,I have to dynamically extract the environment on which the code is currently running?Any pointers on how to do it?Regards,Shalul Rohilla

Hi Jorg,If I implement a JMS queue in CQ, will I be able to access this JMS from external system? Any idea?Regards,Shallu Rohilla

Hi Jörg/Scott,My requirement is to submit jobs to job queue in CQ similar to a JMS system and then a third party system will listen to the queue and extract the messages/jobs. My problem here is though I can submit jobs/messages through Sling eventing but how do I listen to these messages from exter...

Hi,Can we have an internal messaging queue in CQ similar to JMS and if yes is it possible for an external system to poll that queue?Regards,Shallu Rohilla