I think my question is not correct. Now I have updated.Actually the given solution only works for point 1.  1. xyz:pubic --> property value can be 'yes'                           or       xyz:pubic --> property value is not defined means null.     2.  xyz:pubic --> property not available/exist for D...

Hi Team, I am fetching some DAM assets based on the below property (xyz:public).1)    Below is the condition it should use to fetch the result.      1. xyz:pubic --> property value can be 'yes'                           or       xyz:pubic --> property value is not defined means null.     2.  xyz:pub...

Hi Team, Can someone suggest how to delete DAM documents which is having particular property either servlet or groovy script or any other methods?  

https://gist.github.com/floriankraft/8b3720464318cd5cd9e2 helped me to find the required list. SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE(node, "/search/in/path") AND PROPERTY(node.[propertyName], "DATE") LIKE "%" Thanks a lot.  

thanks for reply kiran. property.Type is String for all docs around 5k. only few may be 10 to 20 mistakenly created with property.Type=Long, need to identify those using qury

Thanks for the reply sanket. This is fetching all records.property.Type=Long  is not working it seems. 

Hi Team,I am trying to get list of documents with below property (ingredion:productId). I able to fetch the properties but I need only the properties with type Long.How to query that, can someone suggest.   Below is the query i am using to fetch the records.But I want only the records whose property...