3 Replies Latest reply on Jan 24, 2013 5:44 AM by aklimets

    Insensitive search using query builder

    Nishant.Varandani

      Hi,

       

      I want to convert below sql query so as to use for querybuilder .

       

      select * from nt:unstructured where jcr:path like '/content/dam/company/project/data/%' and UPPER(ctn_no) LIKE 'HD%' or UPPER(family_name) LIKE 'HD%' order by jcr:score desc

       

      I tried with below values from querybuilder component.

       

      type=nt:unstructured

      path=/content/dam/company/project/data

      group.1_property=ctn_no

      group.1_property.value=HD%

      group.1_property.operation=like

      group.p.or = true

      group.2_property=family_name

      group.2_property.value=HD%

      group.2_property.operation=like

      orderby=jcr:score

      orderby.sort=desc

       

      To do a case insensitive search, I am always converting input parameter to upper case so I can match that parameter with the value from CRX.

       

      Please guide me if I am in right direction and how can I do case insensitive search using querybuilder with above approach.

       

       

      Thanks,

      Nishant Varandani