oh i know it will be fairly easy to get this through java class but unfortunately writing jive code is not an option for me and if there is no way to check property length in query builder query parameter , i will like to work on fixing sql query to print node path and property value where my condit...

Thanks for your generosity.can you help me updating my sql query to print videoId property value as well ? doesn't matter , what i write but that sql is returning only full JCR path where that property exits but i need exact value of videoId property as second column.for the export result issue, i w...

thanks for your reply but i need some other information which are not coming out using sql and i can not export result set using CRX

I am trying to find a way to search for a particular property and check if its value exceeding certain characters and print the complete node path where that property exists along with property value.I was able to get the path detail using CRXDE sql 2 query like thisCan someone help me converting th...