1

We are migratiing from aem 6.0 to 6.1

We faced the following problem:
in 6.0 following request was successfull:

SELECT * FROM [oak:Unstructured] AS s WHERE ISDESCENDANTNODE(s,'/etc/commerce/products/goods') AND [cq:commerceType]='product' AND ([my_property] = '123456P')

In cq 6.1 mentioned request doesn't respond anything but if replace request a bit(use like instead of = ) - it works:

SELECT * FROM [oak:Unstructured] AS s WHERE ISDESCENDANTNODE(s,'/etc/commerce/products/goods') AND [cq:commerceType]='product' AND ([my_property] like '%123456P')

Can you explain why ?

P.S.

This problem is unstable. It reproduces on single instance but on 2 other - not.

Maybe something with indexing?

gstackoverflow
  • 36,709
  • 117
  • 359
  • 710

1 Answers1

0

Problem was related with

upgrading cq 6.0 to 6.1.

If to install cq 6.1 from scratch - problems doesn't happen.

P.S.

looks like upgrading issue related with updating OOTB cq libraries.

gstackoverflow
  • 36,709
  • 117
  • 359
  • 710