query builder query to find property and value | Community
Skip to main content
A
AnujPathak
Level 3
October 3, 2017

query builder query to find property and value

  • October 3, 2017
  • 2 replies
  • 30249 views

I am trying to find a way to search for a particular property and check if its value exceeding certain characters and print the complete node path where that property exists along with property value.

I was able to get the path detail using CRXDE sql 2 query like this

Can someone help me converting this to query builder query?

I tried these but looks like it is returning everything

                                       or

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    VeenaVikraman
    Community Advisor
    VeenaVikramanCommunity Advisor
    Community Advisor
    October 4, 2017

    If the SQL 2 query is working for you ; why are you looking for a query-builder query ? There wont be any kind of performance impact if you use any of these

    VeenaVikraman
    Community Advisor
    VeenaVikramanCommunity Advisor
    Community Advisor
    October 4, 2017

    Still to answer your question

        As far as my memory serves me right, there is no direct query in Query Builder. The max what you can do is to fetch the property nodes which you are searching and on the result set , you check the length of the values and print those nodes which meets your criteria .

    JcrPropertyPredicateEvaluator ("The Adobe AEM Quickstart and Web Application.") will tell you what all properties are available for Property Predicate

    Lets say I want to search for nodes which has a property = textIsRich under /content/geomtrixx. Then I would write a query like below

    path=/content/geometrixx

    type=nt:unstructured

    property=textIsRich

    property.operation=exists

         Now I will write this query in my Java class and when the result set is returned , I will run through the values of this property and check for the length of the values and store those paths in a collection accordingly

    // create query description as hash map (simplest way, same as form post)
        Map<String, String> map = new HashMap<String, String>();
       
    // create query description as hash map (simplest way, same as form post)
        map.put("path", "/content/geometrixx");
        map.put("type", "nt:unstructured");
        map.put("property", "textIsRich"); 
        map.put("property.operation", "exists");
       Query query = builder.createQuery(PredicateGroup.create(map), session);
        SearchResult result = query.getResult();
      
         // iterating over the results
        for (Hit hit : result.getHits()) {
           String path = hit.getPath();
           Resource resource = resourceResolver.getResource(path);
            Node node = resource.adaptTo(Node.class);
            // read property values
            String textIsRich = node.getProperty("textIsRIch").getString();
            //write the logic to check the length and then if it matches add that to a collection or write to a file
        }
    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    November 13, 2018

    AEM Query Structure:- Queries are always the backbone of any structure and from performance point of view. It becomes extremely important to write most optimized query. Lets decompose a query and see what all it consist of :-

    • Predicates – If no parameter is provided, predicate type is mirrored in final query
    • Parameter – Predicate Parameter
    • Value – Value of predicate

    Standard Predicates : Deep understanding of predicates is necessary if you want to Optimize any if your Search Query.

    • path : This is used to search under a  particular hierarchy only.
      • path.self=true : If true searches the subtree including the main node given in path,  if false searches the subtree only.
      • path.exact=true : If true exact path is matched, if false all descendants are included.
      • path.flat=true : If true searches only the direct children .
    • type: It is used for searching for a  particular nodetype only.
    • property: This is used to search for a specific property only.
      • property.value : the property value to search . Mutilple values of a particular property could be given using property.N_value=X , where N is number from 1 to N.
      • property.depth : The number of additional levels to search under a node. eg. if property.depth=2 then the property is searched under
        1
        (@jcr:title = 'foo'or */@jcr:title = 'foo'or */*/@jcr:title = 'foo')
        • property.and : If multiple properties are present , by default an OR operator is applied. If you want an AND , you may use property.and=true
        • property.operation : “equals” for exact match (default), “unequals” for unequality comparison, “like” for using the jcr:like xpath function , “not” for no match , (value param will be ignored) or “exists” for existence match .(value can be true – property must exist).

    Good Reference Read:- https://hashimkhan.in/2015/12/02/query-builder/ , http://www.aemcq5tutorials.com/tutorials/adobe-aem-cq5-tutorials/aem-query-builder/ and Query Builder API

    Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...