<?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: AEM6.3 - QueryBuilder - filter by properties that contains some string in Adobe Experience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240480#M48047</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="text-align: left;"&gt;Are you using SQL2? if yes, you can use below query&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: 'arial black', 'avant garde';"&gt;&lt;EM&gt;SELECT parent.* FROM [cq:Page] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '/content') AND child.[sling:vanityPath] IS NOT NULL&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, helvetica, sans-serif;"&gt;&lt;CODE style="font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; color: inherit;"&gt;you can use child.[sling:vanityPath] LIKE 'en_us' also&lt;/CODE&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;if you are using &lt;STRONG&gt;Query Builder Debugger Tool&lt;/STRONG&gt;, you can write like below:&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;type=nt:base&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;path:/content/&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;property:jcr:content/sling:vanityPath&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;property.operation:exists&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;you can use other property operation also e.g. "like" to search for particular keyword for vanity urls in properties&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 08 May 2018 22:23:37 GMT</pubDate>
    <dc:creator>arunpatidar</dc:creator>
    <dc:date>2018-05-08T22:23:37Z</dc:date>
    <item>
      <title>AEM6.3 - QueryBuilder - filter by properties that contains some string</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240478#M48040</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;We are using QueryBuilder to do the search on our website.&lt;/P&gt;&lt;P&gt;We have a list of vanitys url's stored on a property called sling:vanityPath that is a multivalued property.&lt;/P&gt;&lt;P&gt;I want to put on the search criteria a restriction to search pages that contains some string on the vanity urls.&lt;/P&gt;&lt;P&gt;For example:&lt;/P&gt;&lt;P&gt;search pages that contains "en_us" on the property sling:vanityPath (that is a multivalued property).&lt;/P&gt;&lt;P&gt;Is it posible to do something like this?&lt;/P&gt;&lt;P&gt;I could not found anything similar on the internet, I appreciate any help.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you very much in advance.&amp;nbsp; &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 May 2018 21:43:41 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240478#M48040</guid>
      <dc:creator>elizabethp60981</dc:creator>
      <dc:date>2018-05-08T21:43:41Z</dc:date>
    </item>
    <item>
      <title>Re: AEM6.3 - QueryBuilder - filter by properties that contains some string</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240479#M48043</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am looking for another answers,&lt;/P&gt;&lt;P&gt;and if it is posible to put a condition to verify if a property exists on the parent page of this page, this is something I can use.&lt;/P&gt;&lt;P&gt;is this posible or easier of my first question???&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I remain attentive.&lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 May 2018 21:56:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240479#M48043</guid>
      <dc:creator>elizabethp60981</dc:creator>
      <dc:date>2018-05-08T21:56:01Z</dc:date>
    </item>
    <item>
      <title>Re: AEM6.3 - QueryBuilder - filter by properties that contains some string</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240480#M48047</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="text-align: left;"&gt;Are you using SQL2? if yes, you can use below query&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: 'arial black', 'avant garde';"&gt;&lt;EM&gt;SELECT parent.* FROM [cq:Page] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '/content') AND child.[sling:vanityPath] IS NOT NULL&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, helvetica, sans-serif;"&gt;&lt;CODE style="font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; color: inherit;"&gt;you can use child.[sling:vanityPath] LIKE 'en_us' also&lt;/CODE&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;if you are using &lt;STRONG&gt;Query Builder Debugger Tool&lt;/STRONG&gt;, you can write like below:&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;type=nt:base&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;path:/content/&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;property:jcr:content/sling:vanityPath&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: 'arial black', 'avant garde';"&gt;property.operation:exists&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;you can use other property operation also e.g. "like" to search for particular keyword for vanity urls in properties&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 May 2018 22:23:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240480#M48047</guid>
      <dc:creator>arunpatidar</dc:creator>
      <dc:date>2018-05-08T22:23:37Z</dc:date>
    </item>
    <item>
      <title>Re: AEM6.3 - QueryBuilder - filter by properties that contains some string</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240481#M48051</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;It works!&lt;/P&gt;&lt;P&gt;Thank you very much for the help!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG src="https://experienceleaguecommunities.adobe.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 May 2018 13:40:49 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem6-3-querybuilder-filter-by-properties-that-contains-some/m-p/240481#M48051</guid>
      <dc:creator>elizabethp60981</dc:creator>
      <dc:date>2018-05-09T13:40:49Z</dc:date>
    </item>
  </channel>
</rss>

