Skip to main content
Participant
December 13, 2019
Answered

DAM: can not search asset with SQL2 by metadata if its data type is Long or Integer. Please help

  • December 13, 2019
  • 1 reply
  • 395 views

Adobe Experience Manager, Version: 6.4.5.0

I tried to search item on one of DAM servers with sql2:

SELECT * FROM [dam:Asset] as node WHERE ISDESCENDANTNODE (node, '/content/dam/products/') and (node.[jcr:content/metadata/xmp:item-num]=12345).

If data type for xmp:item-num is string, it works fine. But if chsanging datas type to Integer/Long, return nothing. Obviously this is a system bug because the same SQL2 works on another server. How to fix trhis problem?

 

Thanks,

James

This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer Bani Verma

Hi there,

Please post your query in the following community: https://forums.adobe.com/community/experience-cloud/marketing-cloud/experience-manager.

Experts here will be able to assist you better. Thanks!

1 reply

Bani Verma
Bani VermaCorrect answer
Legend
December 16, 2019

Hi there,

Please post your query in the following community: https://forums.adobe.com/community/experience-cloud/marketing-cloud/experience-manager.

Experts here will be able to assist you better. Thanks!