Hi @SantoshSai , query is using the latest index. But when I search asset name in asset search not returning results. And this is not for all assets. for some id's search is working and some id's it's not. And this was not a issue before.

Hi,We recently completed the stage deployment with the updated index. However, asset search is not working for all assets. When I try searching for certain asset IDs in stage, it returns 0 results. I also verified using Query Builder, but the results are still missing. Interestingly, if I edit an as...

Hi @arunpatidar , after removing the property from the oak:index then the query is working.  <samsExpirationDate jcr:primaryType="nt:unstructured" name="jcr:content/metadata/productdata/samsExpirationDate" propertyIndex="{Boolean}true"/> I have added the property in oak like thi...

Even I thought same. but for few assets samExpirationDate property type is Date. Still no results. 

Hi,this is my query, path=/content/damtype=dam:Asset1_group.property=jcr:content/metadata/productdata/itemStatus1_group.property.1_value=D1_group.property.2_value=X2_group.property=jcr:content/metadata/productdata/samsExpirationDate2_group.property.operation=exists3_group.daterange.property=jcr:cont...

get seesion from service user and in the service user I have provided the read and write permission for /content/dam folder

Query is failing to give results in dev cloud. There's no error just query results are 0. And same query is working when deployed to local. When I just run the query in dev crxde tools able to get the result. Via code trying to run failed get the results.

Hi, String sqlQuery = "SELECT * FROM [dam:Asset] AS asset " + "WHERE ISDESCENDANTNODE(asset, '/content/dam') " + "AND asset.[jcr:path] NOT LIKE '/content/dam/archive/%' " + "AND asset.[jcr:content/metadata/productdata/samsExpirationDate] IS NOT NULL " + "AND asset.[jcr:co...

Hi @kautuk_sahni ,Thanks for checking. I was able to resolve and I have marked the right answer.

Hi @arunpatidar ,I want to delete all the versions except "jcr:rootVersion". That is the requirement. We are creating version of assets to retain the metadata when we update the assets. Once the asset is updated and created a version. We want delete that version. Customer don't need the version of a...