Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

New Here ,
Dec 13, 2019 Dec 13, 2019

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

363
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Adobe Employee , Dec 16, 2019 Dec 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!

Translate
Adobe Employee ,
Dec 16, 2019 Dec 16, 2019
LATEST

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!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines