Hi Kalyanar,Could you please answer one more thing, how to set the indexing happen automatically. Setting the reindex property to true triggers the indexing and then it is set to false once the indexing has happened. So when a new record is added which has the indexed property, do I need to run the ...

Hi Kalyanar,I checked the explain plan after adding a Property Index and its giving much better performance, many thanks for sharing this.Thanks, Souradeep

I understand when you said to index the property, the thing is in that case I would have to add an additional distinguishable property for each asset which will tell me that its the asset I am looking for. Is there a way I can do it without creating a new property just by utilizing the path.

Thanks for the update, I also have another property for each asset which can tell me its in which path. If I use like predicate, it is working fine. Can you tell me if using an index property will better the performance than using this predicate?

I went through the steps mentioned to create a index, but I don't think it is the solution to my problem.What I am asking is we are looking to find the assets under a given path which has a given property. However there are multiple such paths here with similar pattern, so I would like to put someth...

Thanks for the update. Could you please provide the steps to do that?

Hi,Is there a way I can use regex or something similar to narrow down the number of nodes across which a query will search to find the results.I am currently using like this:SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE(s,'/content/dam/a') and [jcr:content/metadata/sku]='XYZ'However I know m...

Thanks for your response.However I had already seen those references earlier to adding this comment. I want to exclude the system steps from the step back drop-down and these references do not talk about the same.

Hi,Is there a way that only participant steps would appear in the Previous Step dropdown while stepping back. Currently both system and participant steps appear.Thanks,Souradeep