Thanks @DEBAL_DAS  for your time with this, for now sticking with initial approach mentioned in the post with batching. 

Thanks @DEBAL_DAS ... i could have but the other properties i am searching for are a mix of properties and nodes containing properties.. I ran batching for the query in the original question  and it seems to have done the job but will keep an eye on anyones input here

Sure @kautuk_sahni .HTH. (function($document, $) {"use strict";//form id defined in /libs/wcm/core/content/sites/properties/jcr:content/body/content/contentvar PROPERTIES_FORM = "cq-sites-properties-form";$document.on("foundation-contentloaded", function(){$("#shell-propertiespage-doneactivator").on...

I do have a question on query builder query and if it is the apt way to proceed on 6.5.8I have a structure as below/var/test/user  /A    /0222223ead  /B   /234534rrr43 and  58 more direct children for /var/test/userI want to query for a property with a value "x", and link contains "/content/dam/y" a...

Thanks @arunpatidar .. If date time field was in a  format with hhmmss, i had to fill in 00:00.I went ahead with creating a date field and storing it in hh mm ss but displaying in dd-mm-yyyy format, and while copying i had to clear the date time field and then set it with the value persisted. 

Thanks @Jörg_Hoh .This along with @lukasz-m 's response helped. Much appreciated. Using OOTB index. I have always wondered, what are the ways to identify what index I have to create? Also, please let me know the steps if there are any for debugging this.

Anyone please ? 

Thanks @arunpatidar . Below also worked. It is just that it does a click on entire field vs just the icon for calendar.If i may ask do you have any inputs on https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-4-update-a-datetime-field-changing-the-valueformat-and/m-p/435...

Running the below query throws error [2]. Is it the like operator causing trouble? Do we know how i could avoid traversal warning?Explain query throws a 150000 traversal limit error. path = /content/dam/en/we-retailtype= nt:unstructured1_property=metadata/@dc:format1_property.operation = like1_prope...