Oak indexing in aem 64 for dam:assetcontent

[NitroHazeDev]

I was trying to run a query with type - dam:AssetContent and on running it in query builder ui I get the result but I see an error in the error login traversing and that there is no index while I mocked up the dam:asset index under oak:index in aem

property - metadata/cq:tags - throws no error while

property - metadata/customprop - throws traversal error

Custom prop is of type “long”

query

type- dam:AssetContent

path- /content/dam

property - metadata/customprop

property.value - 123

could i be missing something basic ? Please advise

[Peter_Puzanovs · Accepted solution]

Hey NitroHazeDev,

Adobe have recorded beautiful Gem on Indexing: Best Practices for Indexing and Queries in AEM Have you seen it(must see)?

By the sound of it, it looks like you are missing index for metadata/customprop.

We also have this brilliant tool that allows to create indexes easily[1]

[1] Oak Utilities : Index Definition Generator

Thank you!

Regards,

Peter

[smacdonald2008]

great answer Peter!

[NitroHazeDev]

So i did refer to it and created indices based on it but in vain . Then checked Oak Utilities : Index Definition Generator , validated and it looked right as well. I loved the generator url makes life easier

BUT the main part that was incorrect was the "async" that was a misspell.. wonder if i was dozing but yeah , correcting the spelling helped.

Thanks