topic Re: Xpath selectnodes query for given date in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/xpath-selectnodes-query-for-given-date/m-p/298171#M251301 <HTML><HEAD></HEAD><BODY><SPAN>How about this:</SPAN><BR /><BR /><SPAN>search.selectNodes("//*[number(translate(substring(@cm:created,1,10),'-',''))&gt;20130711]");</SPAN><BR /><BR /><SPAN>This is to compare the date only not a full timestamp, but they idea with be applicable to timestamps as well.</SPAN><BR /><BR /></BODY></HTML> Fri, 12 Jul 2013 09:38:59 GMT kamielvdz 2013-07-12T09:38:59Z Xpath selectnodes query for given date https://connect.hyland.com/t5/alfresco-archive/xpath-selectnodes-query-for-given-date/m-p/298170#M251300 Friends,I have query which runs using TYPE filter/property value filter and date range filter.Which runs fine on LUCENE.I want same query to be run using XPATH selectNodes query in java.e.g./app:company_home/cm:T3/cm:Trade/cm:test_9b8adc70-6a83-4104-8783-53d569b04801/cm:Foods/*/*[subtypeOf('t3:test' Thu, 11 Jul 2013 07:22:38 GMT https://connect.hyland.com/t5/alfresco-archive/xpath-selectnodes-query-for-given-date/m-p/298170#M251300 g_rathod 2013-07-11T07:22:38Z Re: Xpath selectnodes query for given date https://connect.hyland.com/t5/alfresco-archive/xpath-selectnodes-query-for-given-date/m-p/298171#M251301 <HTML><HEAD></HEAD><BODY><SPAN>How about this:</SPAN><BR /><BR /><SPAN>search.selectNodes("//*[number(translate(substring(@cm:created,1,10),'-',''))&gt;20130711]");</SPAN><BR /><BR /><SPAN>This is to compare the date only not a full timestamp, but they idea with be applicable to timestamps as well.</SPAN><BR /><BR /></BODY></HTML> Fri, 12 Jul 2013 09:38:59 GMT https://connect.hyland.com/t5/alfresco-archive/xpath-selectnodes-query-for-given-date/m-p/298171#M251301 kamielvdz 2013-07-12T09:38:59Z