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

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

Copy link to clipboard

Copied

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

TOPICS
Troubleshooting

Views

249

Likes

Translate

Translate

Report

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!

Likes

Translate

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

Copy link to clipboard

Copied

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!

Likes

Translate

Translate

Report

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