[JCRTOOLS-61] Jcr full text query fails to find specific uuid strings in text image component Created: 27/Jan/23  Updated: 02/Mar/23  Resolved: 02/Mar/23

Status: Closed
Project: JCR Tools
Component/s: None
Affects Version/s: 1.3
Fix Version/s: None

Type: Bug Priority: Neutral
Reporter: Carlos Cantalapiedra Assignee: Jaromir Sarf
Resolution: Obsolete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: XML File bold.jpg-1.xml     XML File bold.jpg.xml     XML File notFound.jpg.xml     XML File ol.jpg.xml    
Issue Links:
Problem/Incident
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:
Team: Nucleus
Work Started:

 Description   

Steps to reproduce

  1. Go to assets app https://nightly.magnolia-cms.com/.magnolia/admincentral#app:dam:jcrBrowser
  2. Import notFound.jpg.xml 
  3. Go to https://nightly.magnolia-cms.com/.magnolia/admincentral#app:pages-app:detail;/travel/contact:edit
  4. Edit the existing or add new textImage component.
  5. To to image tab
  6. Select the imported asset in the link field. Save.
  7. Go to JCR tools app https://nightly.magnolia-cms.com/.magnolia/admincentral#app:jcr-tools:
  8. Select the website workspace, paste this query: 
  9. select * from [mgnl:component] as p where contains(p.*, 'ffffffff-805e-fd3d-ffff-ffffc3725c50')

Expected results

A result is provided

Actual results

Nothing is found

Workaround

Development notes

select * from [mgnl:component] where [image] = 'jcr:ffffffff-805e-fd3d-ffff-ffffc3725c50' doesn't work as well

Additional observation:

  1. Go to JCR browser https://nightly.magnolia-cms.com/.magnolia/admincentral#app:jcr-browser-app:browser;/travel/contact/main/00/image::
  2. Change the link value to something which does not have aaaa or ffff on the 4th position (8-4-4-4-12), e.g.: 
  3. Go to https://nightly.magnolia-cms.com/.magnolia/admincentral#app:jcr-tools
  4. select * from [mgnl:component] as p where contains(p.*, 'ffffffff-805e-fd3d-ffff-ffffc3725c50') 
  5. Check the query found the component


 Comments   
Comment by Roman Kovařík [ 01/Feb/23 ]

ccantalapiedra looks like you've attached a fix version of the asset (with ffffffff-805e-fd3d-0000-000071e9f4f8). The same one is attached to the support ticket.

nstutz even if I change the UUID to the one reported on the support ticket: notFound.jpg.xml (ffffffff-805e-fd3d-ffff-000071e9f4f8) the query still returns the result. Are you sure you were looking for the correct UUID and not for another UUID from the asset (there are some sub nodes in the asset)? 

Comment by Carlos Cantalapiedra [ 15/Feb/23 ]

Hi rkovarik ,

You are right, after checking it carefully I saw that, for some reason, the asset wasn't uploaded with the uuid ffffffff-805e-fd3d-ffff-ffffc3725c50. After removing it and uploading it again (the one named ol.jpg.xml) the asset was found through the query:

select * from [mgnl:component] as p where contains(p.*, 'ffffffff-805e-fd3d-ffff-ffffc3725c50') 

I will ask Nicole to check if the uuid is correct

Comment by Jaromir Sarf [ 23/Feb/23 ]

Discovery:
Cannot reproduce the issue. Now we are waiting for customer to double check the issue to provide detailed steps to reproduce or find the issue obsolete.

Generated at Mon Feb 12 02:17:33 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.