<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: querybuilder search on Property case insensitive in Adobe Experience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198009#M107267</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;As I understand it, the issue is not really XPath vs. SQL2, but really with the QueryBuilder. But you might want to ask in the other thread to be sure.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 13 Mar 2019 19:18:59 GMT</pubDate>
    <dc:creator>justin_at_adobe</dc:creator>
    <dc:date>2019-03-13T19:18:59Z</dc:date>
    <item>
      <title>querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/197999#M107257</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I have seen a similar question asked but never found a definitive answer. If I want to query a bunch&amp;nbsp;of nodes for a particular property value using the "like" operation. Is there a way to make that query case insensitive?&lt;/P&gt;&lt;P&gt;appreciate any help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Sample Query&amp;nbsp;&amp;nbsp;that is case sensitive:&lt;/P&gt;&lt;PRE class="prettyprint linenums" data-language=""&gt;path=/content/project/en type=cq:Page 1_orderby=@jcr:content/date 1_orderby.sort=desc 3_property=jcr:content/cq:template 3_property.value=/apps/project/templates/person 3_property=jcr:content/jcr:title 4_property.1_value = %nameFragment% 4_property.operation = like&lt;/PRE&gt;&lt;P&gt;Best,&lt;/P&gt;&lt;P&gt;Dmitry&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Oct 2015 02:27:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/197999#M107257</guid>
      <dc:creator>Dterner</dc:creator>
      <dc:date>2015-10-16T02:27:27Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198000#M107258</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="font-family: adobe-clean, sans-serif; font-size: 13.63636302948px; font-style: italic; line-height: 18px;"&gt;When working with the QueryBuilder, it is strongly recommended that you use the QueryBuilder debugger tool. You can perform different tests and see what works and what does not.&amp;nbsp;For more information, see&amp;nbsp;&lt;/SPAN&gt;&lt;A href="http://cq-ops.tumblr.com/post/23543240500/how-to-use-cqs-query-debugger-tool" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-style: italic; font-size: 13.63636302948px; font-family: adobe-clean, sans-serif; color: rgb(51, 153, 204); text-decoration: none; cursor: pointer; line-height: 18px;" target="_blank"&gt;How to Use CQ’s Query Debugger Tool&lt;/A&gt;&lt;SPAN style="font-family: adobe-clean, sans-serif; font-size: 13.63636302948px; font-style: italic; line-height: 18px;"&gt;.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Oct 2015 02:27:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198000#M107258</guid>
      <dc:creator>smacdonald2008</dc:creator>
      <dc:date>2015-10-16T02:27:27Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198001#M107259</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks&amp;nbsp;Scott, the search debugger tool is very helpful and so is the &lt;A href="http://adobe-consulting-services.github.io/acs-aem-tools/features/query-editor.html" target="_blank"&gt;Query Editor&lt;/A&gt; that is part of the AEM tools put out by Professional Services.&amp;nbsp;&lt;/P&gt;&lt;P&gt;The query itself is perfectly fine and produces the required results. However the querying is case sensitive and I would&amp;nbsp;like to ignore case in this instance. Is there a way to achieve this using the querybuilder API? Or does this require a custom predicate?&amp;nbsp;&lt;/P&gt;&lt;P&gt;If the latter, has anyone seen a similar example in the wild?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Oct 2015 02:27:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198001#M107259</guid>
      <dc:creator>Dterner</dc:creator>
      <dc:date>2015-10-16T02:27:27Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198002#M107260</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Dmitry,&lt;/P&gt;&lt;P&gt;The trick is to lower case the property&lt;/P&gt;&lt;P&gt;4_property=fn:lower-case(jcr:content/jcr:title)&lt;/P&gt;&lt;P&gt;and then lower case the search term&lt;/P&gt;&lt;P&gt;4_property.1_value = %namefragment%&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Justin&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Oct 2015 02:27:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198002#M107260</guid>
      <dc:creator>justin_at_adobe</dc:creator>
      <dc:date>2015-10-16T02:27:27Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198003#M107261</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks Justin, that did the trick.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Oct 2015 02:27:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198003#M107261</guid>
      <dc:creator>Dterner</dc:creator>
      <dc:date>2015-10-16T02:27:27Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198004#M107262</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I don't get this to work in &lt;A href="http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&amp;amp;query=path%3D%2Fcontent%2Fwe-retail%0D%0Atype%3Dcq%3APage%0D%0A1_property%3Dfn%3Alower-case%28jcr%3Atitle%29%0D%0A1_property.value%3Denglish%0D%0A1_property.operation+%3D+like" title="http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&amp;amp;query=path%3D%2Fcontent%2Fwe-retail%0D%0Atype%3Dcq%3APage%0D%0A1_property%3Dfn%3Alower-case%28jcr%3Atitle%29%0D%0A1_property.value%3Denglish%0D%0A1_property.operation+%3D+like"&gt;http://localhost:4502/libs/cq/search/content/querydebug.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Using this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;path=/content/we-retail&lt;/P&gt;&lt;P&gt;type=cq:Page&lt;/P&gt;&lt;P&gt;1_property=fn:lower-case(jcr:content/jcr:title)&lt;/P&gt;&lt;P&gt;1_property.value=english&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 20 Jun 2018 12:24:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198004#M107262</guid>
      <dc:creator>Feike_Visser1</dc:creator>
      <dc:date>2018-06-20T12:24:37Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198005#M107263</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;yeah it doesn seem to work via property map, though xpath works&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'courier new', courier;"&gt;/jcr:root/content///element(*, cq:Page)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'courier new', courier;"&gt;[(fn:lower-case(jcr:content/@jcr:title) = 'hi') ]&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, helvetica, sans-serif;"&gt;There is additonal support in oak index definitions to run such query optimally by defining function indexes &lt;A href="https://issues.apache.org/jira/browse/OAK-3574?focusedCommentId=15474001&amp;amp;page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-15474001" title="https://issues.apache.org/jira/browse/OAK-3574?focusedCommentId=15474001&amp;amp;page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-15474001"&gt;[OAK-3574] Query engine: support p=lowercase('x') and other function-based indexes - ASF JIRA&lt;/A&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 22 Jun 2018 04:13:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198005#M107263</guid>
      <dc:creator>amalhotr</dc:creator>
      <dc:date>2018-06-22T04:13:17Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198006#M107264</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi ,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am&amp;nbsp; trying to&amp;nbsp; add the &lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;fn:lower-case(jcr:content/jcr:title) in my querybuilder code in my servlet&amp;nbsp; but lowercase function doesnt work.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;When QueryBuilder creates a Xpath query it resolves to below :&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;fn:lower-case_&lt;STRONG&gt;x0028__x0040&lt;/STRONG&gt;_jcr:content/@boxTitle_&lt;STRONG&gt;x0029_&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;&lt;STRONG&gt;Has anyone faced this issue?&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 13 Mar 2019 10:28:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198006#M107264</guid>
      <dc:creator>farahz913310</dc:creator>
      <dc:date>2019-03-13T10:28:56Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198007#M107265</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;A href="https://experienceleaguecommunities.adobe.com/people/farahz913310"&gt;farahz913310&lt;/A&gt;​ Based on the discussion in &lt;A href="https://forums.adobe.com/message/10107969"&gt;Re: AEM 6.2  "fn:lowercase"  is not working &lt;/A&gt;&amp;nbsp; (and some other linked threads), it appears that the function described in my original "correct" answer (from 2015) stopped working with AEM 6.2 and was never officially supported. That thread has a proposed solution which does (apparently) work in 6.2 and beyond.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 13 Mar 2019 15:04:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198007#M107265</guid>
      <dc:creator>justin_at_adobe</dc:creator>
      <dc:date>2019-03-13T15:04:28Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198008#M107266</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks @justin.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As mentioned here &lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt; &lt;/SPAN&gt;&lt;A _jive_internal="true" data-containerid="5429" data-containertype="14" data-objectid="10107969" data-objecttype="2" href="https://forums.adobe.com/message/10107969#10107969" style="font-size: 16px; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; color: #3a91d7;"&gt;Re: AEM 6.2&amp;nbsp; "fn:lowercase"&amp;nbsp; is not working &lt;/A&gt;,So the better solution is use SQL2 instead of Xpath query ?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 13 Mar 2019 15:24:45 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198008#M107266</guid>
      <dc:creator>farahz913310</dc:creator>
      <dc:date>2019-03-13T15:24:45Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198009#M107267</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;As I understand it, the issue is not really XPath vs. SQL2, but really with the QueryBuilder. But you might want to ask in the other thread to be sure.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 13 Mar 2019 19:18:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198009#M107267</guid>
      <dc:creator>justin_at_adobe</dc:creator>
      <dc:date>2019-03-13T19:18:59Z</dc:date>
    </item>
    <item>
      <title>Re: querybuilder search on Property case insensitive</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198010#M107268</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you take a look at the below post and see if that helps.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://forums.adobe.com/thread/2326696"&gt;AEM 6.2  "fn:lowercase"  is not working &lt;/A&gt; &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 14 Mar 2019 04:52:41 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/querybuilder-search-on-property-case-insensitive/m-p/198010#M107268</guid>
      <dc:creator>cquser1</dc:creator>
      <dc:date>2019-03-14T04:52:41Z</dc:date>
    </item>
  </channel>
</rss>

