AEM6, Querybuilder, Geometrixx: IllegalStateException when filtering by more than one tag group. Bug?

Avatar

Avatar

paro22

Avatar

paro22

paro22

15-10-2015

Hi, I'm trying to achieve a filtering component that leverages the Querybuilder API and filters pages by tags. It should be possible to filter by multiple tags and taggroups at the same time:

Example:

Group 1
- Tag A or
- Tag B
 or
- Tag C

--- AND ---

Group B
- Tag D or
- Tag E or
- Tag F

My trouble is that I can filter by A, B, C and D but as soon as I add a second tag for the second group I get an exception... So basically I want to see all records that are tagged with A, B, or C AND D or C. This does not work for some reason...

24.09.2014 11:34:23.550 *ERROR* [0:0:0:0:0:0:0:1 [1411583663531] GET /libs/cq/search/content/querydebug.html HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught SlingException java.lang.IllegalStateException: Property index is used even when no index is available for filter Filter(query=select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/cq:tags] in('stockphotography:business/business_concepts', 'stockphotography:business/business_backgrounds') and [jcr:content/metadata/cq:tags] in('properties:style/color', 'properties:style/monochrome/grayscale') /* xpath: //element(*, dam:Asset)[((jcr:content/metadata/@cq:tags = 'stockphotography:business/business_concepts' or jcr:content/metadata/@cq:tags = 'stockphotography:business/business_backgrounds')) and ((jcr:content/metadata/@cq:tags = 'properties:style/color' or jcr:content/metadata/@cq:tags = 'properties:style/monochrome/grayscale'))] */, path=*, property=[jcr:content/metadata/cq:tags=in()])

 

I noticed that this also does not work for the Geometrixx example (/content/geometrixx/en/company/press.html). Is that a known bug?

Here's the geometrixx query:

jcr:title= fulltext= 0_group.property.3_value=stockphotography:business/business_backgrounds 0_group.property.4_value=stockphotography:business/business_concepts 0_group.property=jcr:content/metadata/cq:tags 0_group.p.or=true 1_group.property=jcr:content/metadata/dc:format 1_group.p.or=true 2_group.property=jcr:content/metadata/cq:tags 2_group.p.or=true 3_group.property.1_value=properties:style/color 3_group.property.2_value=properties:style/monochrome/grayscale 3_group.property=jcr:content/metadata/cq:tags 3_group.p.or=true 4_daterange.property=jcr:content/jcr:lastModified 4_daterange.lowerBound= 4_daterange.upperBound= p.limit=24 6_group.0_path=/content/dam/geometrixx/travel 6_group.1_path=/content/dam/geometrixx/portraits 6_group.2_path=/content/dam/geometrixx/offices 6_group.3_path=/content/dam/geometrixx/documents 6_group.4_path=/content/dam/geometrixx/icons 6_group.5_path=/content/dam/geometrixx/movies 6_group.6_path=/content/dam/geometrixx/packshots 6_group.p.or=true 7_group.0_type=dam:Asset mainasset=true p.hitwriter=selective p.properties=jcr:path jcr:primaryType jcr:content/metadata/dc:title jcr:content/metadata/dc:format jcr:content/metadata/dam:ModificationDate jcr:content/metadata/dam:CreationDate jcr:content/metadata/tiff:ImageWidth jcr:content/metadata/tiff:ImageLength orderby=path p.offset=0

Please note that it works fine if you take out '3_group.property.2_value=properties:style/monochrome/grayscale'.

PS: This happens on an AEM6 SP1 (Oak 1.0.5) instance.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Sham_HC

Total Posts

2.1K

Likes

156

Correct Reply

1.2K

Avatar

Sham_HC

Total Posts

2.1K

Likes

156

Correct Reply

1.2K
Sham_HC

15-10-2015

Sounds like bug. File daycare request and refer GRANITE-6975

Answers (0)