3 Replies Latest reply on Apr 29, 2013 4:31 AM by aklimets

    Query Builder wildcard

    aslkit Level 1

      Can query builder use wildcard?

       

       

      My query is like following

       

       

      group.1_path=/var/statistics/pages/content/geometrixx

      orderby=@views

      orderby.index=true

      orderby.sort=desc

       

       

      The result will contain

       

       

      /var/statistics/pages/content/geometrixx/en/products/using-extjs-widgets/.stats/2013  (crxde,  html,  json)

      /var/statistics/pages/content/geometrixx/en/products/using-extjs-widgets/.stats/2013/01  (crxde,  html,  json)

      /var/statistics/pages/content/geometrixx/en/products/using-extjs-widgets/.stats/2013/01/21   (crxde,  html,  json)

       

       

      However, we just expect comparing the "day hit count" only.

       

       

      Should I apply wild card on this?

       

       

      I have tried to use wildcard but no result after search.

        • 1. Re: Query Builder wildcard
          aklimets Adobe Employee

          Can you clarify on what's wrong with the result?

           

          BTW, orderby.index=true workaround is not required anymore since CQ 5.3.

          • 2. Re: Query Builder wildcard
            aslkit Level 1

            Hi,

             

            /var/statistics/pages/content/geometrixx/en/products/using-extjs-widge ts/.stats/2013  (crxde,  html,  json)

            /var/statistics/pages/content/geometrixx/en/products/using-extjs-widge ts/.stats/2013/01  (crxde,  html,  json)

            /var/statistics/pages/content/geometrixx/en/products/using-extjs-widge ts/.stats/2013/01/21  (crxde,  html,  json)

             

            The result contains the statistic included year, month and day.

             

            However, in my case, I only interested for those hit count about day. What should be the query to do so?

            • 3. Re: Query Builder wildcard
              aklimets Adobe Employee

              Use a node type or property constraint that only matches for those 2013/01/21 nodes. If the "view" property only exists on them, you can add this to your query:

               

              property=view

              property.operation=exists